#1
|
|||
|
|||
Macro will not carry forward to next spreadsheet…
I have a workbook to manage people arriving and departing work location. Name, etc. in rows. Every day I sort the data by 3 criteria. Creating the macro is simple and it works fine; except when I copy the spreadsheet tab and create the next day’s sheet, it won’t function. Also, other users can’t use it.
Are there different types of macros? How do I insure it will be useable by my fellow office workers when they log in? By the way, thanks in advance... |
#2
|
|||
|
|||
Yes, there are different kinds of macros. Some are designed to work on one sheet, you may have accidentally created one of those. Others work on the "active sheet".
The best macros can work on any sheet and dynamically figure out where they are and where the data needs to go (if to other sheets). Some macros require you to trigger them, others will trigger themselves by some "event" that occurs. If you post your workbook and/or your code, we can discuss the issues you're having directly. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Back And Forward Commands | lweinreich | Office | 5 | 10-14-2011 07:09 AM |
Tables that carry hidden para styles | Ulodesk | Drawing and Graphics | 4 | 03-10-2011 08:16 AM |
Carry-forward: Tab to Tab? | markg2 | Excel | 11 | 01-30-2011 01:07 AM |
Forward without forwarding formatting | whatever61 | Outlook | 0 | 12-14-2010 08:08 AM |
Can I carry Outlook 2007 with me on a usb stick? | Hansio | Outlook | 2 | 09-09-2010 01:29 PM |