Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching Macros to Custom Buttons
I have created a spreadsheet to track contractor's
submittals (shop drawings) in our office. Mostly this involves alot of date arithmetic. One of the features of the sheet is that I can add a new line for resubmittals. I wrote a macro that creates a new line and then copies formulas into the new line. To simpify the process I created a button which is attached to the file. The problem is that I created the original spread sheet in Excel 5.0. In 5.0 I can select a cell, hit the button and the new line is created under the selected cell. In 2000 when I hit the button the new line is created in a cell under the button!!!! Any Ideas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make custom buttons point to local macros always | Excel Discussion (Misc queries) | |||
make custom buttons for macros on quick access bar excel 2007 | Excel Discussion (Misc queries) | |||
make custom buttons for macros on quick access bar excel 2007 | Excel Discussion (Misc queries) | |||
Buttons and macros | New Users to Excel | |||
assigning macros to several custom buttons | Excel Programming |