Hello folks,
I have been searching for a while for a macro which will bypass the prompt that directs you to enter your password or open in read only when you open an excell worksheet. I assume this will need to me entered into the VBA folder titled "This Workbook". I will have about 80 end users and I am trying to avoid as many prompts as possible. I have eliminated the 'Active X' prompt and understand that you cannot bypass the 'enable macros' prompt.
My question is, Can I add something to he programing I have to eliminate the opening prompt to enter a password and to automatically open the file as read only? This is what I have so far to remove the active X warning and to open a navigation form I built:
Private Sub Workbook_Open()
RemoveActiveXPrompts
Application.DisplayFullScreen = True
Sheets("Sheet1").Select
Range("A1").Select
Navigator.Show vbModeless
End Sub
I am hoping for help to include programing to eliminate the password promt and to open workbook in read only mode. Any help would be greatly appreciated.
BTW, I am running Excell 2003 if that makes any difference. Thanks again
Bookmarks