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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
assigning macro
Hi Bryan
I tried this few days back with your original post. When you click AssignMacro is that displaying just the xls file name or xls!Macroname as below. a12.xls!SaveToDrive (since I have entered 'a12' to Range("A12") and then what happens next.....if you again click the button... If this post helps click Yes --------------- Jacob Skaria |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
assigning macro
It is displaying 'C:\BJS1.xls'!SaveToDrive.
If I delete BJS1.xls from my c: it will say it can not find it. When I open a new template spreadsheet the macro assign should always be 'SaveToDrive' I've created numerous Word templates and this works fine but, now I have a request for doing the same but, with Excel. Am I creating the toolbar button correctly and assigning the macor correctly? Thanks, Bryan "Jacob Skaria" wrote: Hi Bryan I tried this few days back with your original post. When you click AssignMacro is that displaying just the xls file name or xls!Macroname as below. a12.xls!SaveToDrive (since I have entered 'a12' to Range("A12") and then what happens next.....if you again click the button... If this post helps click Yes --------------- Jacob Skaria |
Reply |
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 |