Copying macro and associated button to new file/sheet "in flight"

[Asterix]

cheers...most appreciated

[Norie]

drexcel?

Can you post the URL, or has MrExcel been awarded a doctorate?

[CaptRon]

Open the Control Toolbox Menu (View, Toolbars, Control Box). Then click on the Design Mode icon. Right click on the commandbutton you are wanting to remove and when the option box appears, select Cut.

Ron

[Asterix]

Open the Control Toolbox Menu (View, Toolbars, Control Box). Then click on the Design Mode icon. Right click on the commandbutton you are wanting to remove and when the option box appears, select Cut.

Ron

Thankyou - another glass ceiling removed.

[Asterix]

drexcel?

Can you post the URL, or has MrExcel been awarded a doctorate?

I promoted him as I was so happy with the service.

[Bob Phillips]

Gosh, does that mean we will be generals soon?

[Asterix]

Gosh, does that mean we will be generals soon?

If my increasingly pathetic questions keep getting resolved in the way they are at the moment and I'll vote for this forum at the next election.

[Asterix]

Tee hee, just when I'd thought I had cracked it...

I have now password protected the VBproject (so that normal users "shouldn't" see the code).

Of course, when the macro comes to export the code...kablaamm, it can't.

Must admit, haven't searched extensively yet but (and assuming I don't do this through the userinterface tag as per one of my other threads) how do I unprotect the VBproject using the VB code (and then reprotect it after I've finished exporting)?

[Asterix]

http://www.ozgrid.com/forum/showthread.php?t=23541

Own question answered

[rory]

Question: do you use the Email macro in the original workbook?

[Asterix]

Question: do you use the Email macro in the original workbook?

Been thinking along similar lines. I don't need the macro in the original workbook - it's just a convenient place to store and edit.

Could I just store the email macro in a .bas file outside of Excel?
Does Excel recognise and open .bas files?

[rory]

I was thinking more of using a template file for your first macro. The template can contain the button and code to run the Email macro. Much easier than fiddling with VBProjects, which assumes access to the Project is trusted.

[Asterix]

Maybe thinking too far ahead here, but macro is now in .bas file is my current directory (I can open it in Wordpad).

Ahem...can I protect it from view?

[Asterix]

I was thinking more of using a template file for your first macro. The template can contain the button and code to run the Email macro. Much easier than fiddling with VBProjects, which assumes access to the Project is trusted.

Hmm, will have to investigate template files and their affect on the use of the original file (which is a file used for administration).

Cheers

[rory]

You just create a new file based on the template, populate it with the data (instead of creating a new sheet in your current workbook and populating that), then save it somewhere. You can use Windows security to prevent people viewing any type of file.