Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
assigning macro
I am re-asking this as I'm not getting any info back.
I have a template which I assign a macro to toolbar button, macro is called 'SaveToDrive'. I created the toolbar and then used Commands, Macros, Cutom Button. Right click on button to assign macro ' SaveToDrive', macros in 'the template name' Macro saves as entry in cell A12. Lets's say I enter 'BJS1' into this cell, it saves as BJS1.xls. If I open the template and look at the assign macro, it now says 'BJS1.xls' not 'SaveToDrive'. The template save is written like this: sFilename = "c:\" + strcell" ActiveWorkbook.SaveAs Filename:=sFilename, _ FileFormat:=xlNormal, _ ReadOnlyRecommended:=False, _ CreateBackup:=False Application.Quit Application.StatusBar = "Application Closing." Am I missing something on the save or am I doing something wrong in assigning the macro. I am protecting the sheet and the workbook. Thanks, Bryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assigning value in macro | Excel Programming | |||
assigning macro | Excel Discussion (Misc queries) | |||
assigning a macro to the tab key | Excel Programming | |||
assigning macro to button | Excel Discussion (Misc queries) | |||
Macro assigning help PLEASE | Excel Programming |