Posted to microsoft.public.excel.programming

MattB[_2_] MattB[_2_] is offline

external usenet poster

Posts: 2

protecting sheets from a macro

I am running a macro from an option button in a sheet
named "Summary". The macro make s various formatting
changes, but it needs to unprotect the sheet first. I am
running the following code, but the I get a run time error
when it executes. Can any one help?

Password = "Testpassword"
Worksheets("Summary").Select
Worksheets("Summary").Unprotect Password:=Password

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Protecting/Unprotecting all sheets with macro leads to "image" iss	MikeR	Excel Worksheet Functions	3	February 22nd 10 09:33 PM
Help w/ protecting all sheets	cnote	Excel Discussion (Misc queries)	6	June 27th 06 01:38 PM
Protecting Macro and selected sheets	ST	Excel Discussion (Misc queries)	1	June 6th 06 03:03 PM
Protecting Sheets	Joyce	Excel Worksheet Functions	3	March 20th 06 08:18 PM
Protecting sheets	TV	Excel Discussion (Misc queries)	1	November 29th 04 09:27 PM

All times are GMT +1. The time now is 01:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us