Macro within Excel fixed to a specific sheet

Microsoft Excel 2003 (full product)
November 17, 2009 at 06:10:46
Specs: Windows XP
I have created a spreadsheet which has a template form so that when information is added into an input sheet it links into the relevant section within the form. When we then select send and copy I have wrote the macro which copies the template out, range values it all, then saves it as the next reference number. It also then email the form to the relevant people which has been pre determined. Each person has been given there own password. I have then used a Macro button to bring up a form which asks for a password and when a password is entered it inputs a basic Digital signature. (This has enabled me to have a document flow system via our internal network rather than paying for an expensive document flow system). My only problem is when the form has been copied out the macro button is still linked to the original file. I have put the macro within the sheet but the button is still assigned to the original macro.

See More: Macro within Excel fixed to a specific sheet

Report •

November 17, 2009 at 09:28:29

You would do better to post this in the Office Software forum, which covers Excel and Excel macros.

If you do re-post, can you identify where your macros are. If your workbook is say Form1.xls, is the macro in the VBAProject(Form1.xls) Sheet1 object. or a standard Module such as Module1 in VBAProject(Form1.xls).

If your macros are attached to the workbook itself, you should be able to put them in a standard module attached to PERSONAL.XLS. It will then only be attached to your PC / your copy of Excel.

Also are your macros run from buttons embedded in the worksheets. If so, using Toolbar buttons would separate the functions from the distributed workbooks and keep them on your PC.


Report •
Related Solutions

Ask Question