Macro

Sumir · #1 (**permalink**) 02-23-04, 11:19

Ok.. here is the issue
Record or develop a Save macro that saves the workbook at the Title screen,with the cursor hidden behind the logo. Also how to attach this macro to a textbox labeled Save that appears on each screen of your workbook.Can someone help me out

Thanks
Sumir

Smitty · #2 (**permalink**) 02-23-04, 17:56

Welcome to the Board!

Code:

Sub SaveMe()
  ActiveWorkbook.Save
End Sub

As far as calling it from a TextBox, after your macro is in place, right click the TextBox and select Assign Macro. I'n not sure what you mean by this part:

Quote:

saves the workbook at the Title screen,with the cursor hidden behind the logo.

Hope that helps,

Smitty

Sumir · #3 (**permalink**) 02-24-04, 13:58

thank you for your prompt response. My workbook has a title sheet. I want a macro that will save the work book from that sheet. this means that if i am working on sheet # 255 and when i run this
macro, it should save the workbook from the titlesheet and not sheet #255.

the title sheet of my workbook has a logo. So when the macro runs the cursor should hide behind the logo.please help
thanks
Sumir

Smitty · #4 (**permalink**) 02-24-04, 16:48

OK,

Code:

Sub SaveMe()

 Application.Goto Reference:=['Title Sheet'!A1]
 ' Change Title Sheet name and the location of your logo to suit
 ActiveWorkbook.Save

End With

Assuming that you want to go to the Title Sheet upon closing, this is one method.

Code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

 Application.Goto Reference:=['Title Sheet'!A1]
 ' Change Title Sheet name and the location of your logo to suit
 ActiveWorkbook.Close True

End With

Hope that helps,

Smitty

Internet Services

Web Development

Digital Marketing

Consumer Tech