Posted to microsoft.public.excel.programming

Phil Perry Phil Perry is offline

external usenet poster

Posts: 10

Unprotect Worksheet

I want the macro to unprotect the sheet in order to
carry out some changes and then protect it again at
the end.

Can someone help with the code to unprotect and then
protect.

I have tried
ActiveSheet.Unprotect([password]} but it doesn't like
this!

Thank you for your help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Unprotect a worksheet	Mayumdwl	Excel Worksheet Functions	1	April 21st 09 12:30 AM
unprotect worksheet when......	Wanna Learn	Excel Discussion (Misc queries)	1	December 10th 08 01:14 PM
unprotect a worksheet	shelly	Excel Worksheet Functions	3	December 19th 07 12:37 AM
Unprotect a worksheet	Bryan	Excel Discussion (Misc queries)	11	April 14th 06 02:42 AM
Unprotect worksheet via VBA	Mike Echo	Excel Worksheet Functions	2	March 19th 06 04:52 AM

All times are GMT +1. The time now is 03:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us