Posted to microsoft.public.excel.programming

Casey[_6_] Casey[_6_] is offline

external usenet poster

Posts: 1

Excel VBA error on protected worksheet

I'm a VBA beginner, however I have fixed a similar problem with the
following.

Sub Your_Procedure

ActiveWorkbook.Sheets("Your sheet name").Unprotect (YourPassword)

YourCode

ActiveWorkbook.Sheets("Your sheet name").Protect (YourPassword)

End Sub

---
Message posted from http://www.ExcelForum.com/

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
Edit text format in non-protected cells in protected worksheet	Bonnie	Excel Discussion (Misc queries)	2	April 19th 08 04:48 PM
Macro error when worksheet is protected	Soroya1920	Excel Discussion (Misc queries)	2	August 27th 07 06:42 PM
error accessing a protected worksheet	Erik Jahre	Excel Worksheet Functions	0	February 24th 06 08:32 AM
Excel error message in protected sheets	Rogio	Excel Programming	0	October 29th 03 11:24 PM
Protected cell error - Excel XP & Win98	Tim Barlow	Excel Programming	0	October 7th 03 10:43 PM

All times are GMT +1. The time now is 06:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us