Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotecting worksheets | Excel Discussion (Misc queries) | |||
Unprotecting Worksheets | Excel Discussion (Misc queries) | |||
Unprotecting worksheets | Excel Worksheet Functions | |||
Unprotecting worksheets with a macro | Excel Programming | |||
Protecting & unprotecting worksheets | Excel Programming |