If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

BeforeSave event to bring user to a specific Worksheet not working

Thread starter MoshiM
Start date Jun 19, 2019
Tags

beforesave event save true work

MoshiM

Active Member

Jun 19, 2019

I'm currently using a keybind to suppress messages about document inspector and then save using the following code

Code:

Sub Remove_Information_Save() 'Macro Activates when CTRL+S is used    
    Application.DisplayAlerts = False
    ActiveWorkbook.RemovePersonalInformation = True
    ActiveWorkbook.Save
    Application.DisplayAlerts = True
End Sub

Within the BeforeSave event, neither sheetcodename.activate nor application.goto sheetcodename.range("A1") will work to force the user to save on the specified sheet (Activesheet will not change either). However, when using the normal way to save the code will work correctly.

I'm stumped on this so any help you can provide would be greatly appreciated.