Posted to microsoft.public.excel.misc

Jean Cloutier

Posts: n/a

Allow user to run a macro in protected mode

I want to let other users of my spreadsheet to run a macro in protected mode.

The macro runs the filter for a big spreadsheet and I want to keep the
protection on but let users run the simple macro that hides the blank lines
with auto-filters.

Users get Run-time error 1004 when they click on my macro icon

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
Can T Get Macro To Run!	Nipper	New Users to Excel	2	November 4th 05 04:48 AM
How do I write a macro for a button to send user to a custom view?	Hugnuffer	Excel Discussion (Misc queries)	1	August 16th 05 06:34 PM
Cells User Select Locked after upgrade to Excel 2002	TWilson	Excel Discussion (Misc queries)	1	August 5th 05 12:22 PM
Date macro	Hiking	Excel Discussion (Misc queries)	9	February 3rd 05 12:40 AM
Unable to open excel sheet in Protected mode from VB 6.0	ourspt	Setting up and Configuration of Excel	0	January 26th 05 11:07 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us