Macro to save on title sheet

  • Thread starter Thread starter Dumb_Question
  • Start date Start date
D

Dumb_Question

hi again!

How would I create a macro That save workbook at title sheet with
cursor hidden behind the logo.

Thank you in anticipation.
 
How about using a macro on open that will take you to the sheet and a cell
behine the logo, some thing like this

Private Sub Workbook_Open()
Sheets("title sheet").Select
Range("F2").Select

End Sub



--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Thanks Paul....

I know this might sound dumb but how do I do that?

I have been trying to do it this way ( tools>macros>record macros
without any sucess.

Should I just record a simple macro and then edit it with the code yo
suggested
 
To put in this macro, from your workbook right-click the workbook's icon and
pick View Code. This icon is to the left of the "File" menu this will open
the VBA editor, in the left hand window double click on thisworkbook, under
your workbook name, and paste the code in the window that opens on the right
hand side, press Alt and Q to close this window and go back to your
workbook, now this will run every time you open the workbook. If you are
using excel 2000 or newer you may have to change the macro security
settings to get the macro to run.

Private Sub Workbook_Open()
'Change title sheet to your sheet name
Sheets("title sheet").Select
'Change F2 to a cell behind your logo
Range("F2").Select

End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
paul...that worked great!

i have one question though...how can assign this macro to a text box o
different sheets though?
Again...thank you very muc
 
You do not assign a Workbook_Open macro, it runs when you open the book.

"how can assign this macro to a text box on different sheets though?"
I thought you wanted to go to one sheet and put the cursor behind the logo,
what are you trying to do?
If you want to run it from other sheets just put the code in a module like
this
Sub Test
Sheets("title sheet").Select
Range("F2").Select
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Hi again!

I need to create a text link( would read "save" ) to this macro o
different sheets of the workbook.
Thank
 
Try this to put a button on the sheet to link to the macro, view, toolbars,
forms, click on the button, click on the sheet where you want it, assign the
macro to it. Is this what you want?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Back
Top