How To make any open sheet in WorkBK run Macro.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How To make any open sheet in WorkBK run Macro.

FAQ

Thread Tools

Display Modes

06-22-2014, 11:44 PM

macropod

Windows 7 32bit How To make any open sheet in WorkBK run Macro.

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,512

Quote:

Originally Posted by whatsup

Basically it's important that you can't use ActiveSheet in a macro if you start the macro from another sheet - obvious isn't it?

Unless, of course, your code activates the sheet concerned (e.g. ThisWorkBook.Sheets("MySheet").Activate). But even that requires the sheet to be named for activation. Not a recommended way to program - it's both inefficient and error-prone.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to make an add-in/global macro	hanvyj	Excel Programming	4	12-14-2012 03:23 AM
Make row in one sheet equal column of another	hypertyper	Excel	6	01-31-2012 03:48 PM
confirmation popup on excel sheet macro	mark-gabb	Excel Programming	3	12-22-2011 01:16 AM
Debug for macro run through button only when sheet protected	leahca	Excel Programming	0	11-24-2011 04:47 AM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:12 AM.