Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 37

Limit Macro to Intended worksheet.

Is there a way to limit a macro to work only on ONE work sheet? When I
record a macro I only see an option to store in a WORKBOOK but not a work
sheet.

The problem I have is my macro will distroy my worksheet if I hit the
shortcut key while the wrong worksheet tab is selected. With multiple macros
and multiple worksheets it is only a matter of time before I hit the shortcut
key and get unintended results!

Quin

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
limit on size of macro for excell97	Joe Farruggio	Excel Discussion (Misc queries)	1	September 18th 06 04:45 AM
limit size of worksheet	abfabrob	Excel Discussion (Misc queries)	7	February 22nd 06 05:04 PM
Worksheet Limit	BillCPA	Excel Discussion (Misc queries)	1	February 5th 06 05:19 AM
Worksheet Limit	Jonathan Cooper	Excel Discussion (Misc queries)	0	February 4th 06 08:07 PM
macro to time limit workbook	ditchy	Excel Discussion (Misc queries)	5	April 26th 05 08:43 AM

All times are GMT +1. The time now is 05:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us