Thread: assigning macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bryan Bryan is offline
external usenet poster
 
Posts: 114
Default 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