assigning macro


B

bryan

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
 
Ad

Advertisements

J

Jacob Skaria

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
 
Ad

Advertisements

B

bryan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top