Posted to microsoft.public.excel.programming

Pivot Table/Query Pivot Table/Query is offline

external usenet poster

Posts: 8

Verify protection status within a macro

I have a sheet that is kept protected unless it is time for data entry. I
would like to run a macro that checks for protection status, unprotect if
needed, then sorts, then returns the sheet to the protection status (i.e. if
not protected, leave unprotected, if protected, reprotect).

Help?

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
Determining a worksheet's protection status in VBA	GeorgeJ	Excel Discussion (Misc queries)	2	August 4th 07 12:26 AM
Worksheet Protection status	JimB	Excel Worksheet Functions	1	September 28th 06 11:02 PM
Worksheet protection status	JimB	Excel Discussion (Misc queries)	0	September 28th 06 10:03 PM
Display worksheet protection status in a cell?	Geoff C	Excel Worksheet Functions	2	February 1st 06 03:04 PM
Sheet Protection Status	Andy Williams	Excel Worksheet Functions	1	January 4th 06 04:22 PM

All times are GMT +1. The time now is 12:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us