Results 1 to 4 of 4

Thread: Macro

  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: Macro

    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

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    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:
    saves the workbook at the Title screen,with the cursor hidden behind the logo.
    Hope that helps,

    Smitty

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    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

  4. #4
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •