Unprotecting Worksheets in VB Script
I am using this code to unprotect worksheets in a small program I have:
Sheets("Intropage").Unprotect "ugc" I have since learned, that this does not work in Excel '97. Can anyon help me out with the command that unprotects password protected sheet in '97? Is it possible? Thank -- Message posted from http://www.ExcelForum.com |
Unprotecting Worksheets in VB Script
It will work in Excel 97.
If you are doing it from a commandbutton, change the TakefocusOnClick property to false. -- Regards, Tom Ogilvy "InnerChild " wrote in message ... I am using this code to unprotect worksheets in a small program I have: Sheets("Intropage").Unprotect "ugc" I have since learned, that this does not work in Excel '97. Can anyone help me out with the command that unprotects password protected sheets in '97? Is it possible? Thanks --- Message posted from http://www.ExcelForum.com/ |
Unprotecting Worksheets in VB Script
Try Sheets("Intropage").Unprotect Password:="ugc" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com