I have created a simple work book to create delivery notes and then an end of week invoice.
I have some simple macros running and on my first sheet the macro works perfectly but on the other sheets there is a slight problem with it and I cant work out why.
If there is someone out there that I can send the document to, to see if you could shed some light I would greatly appreciate it.
(Problem is from sheet 2 onwards and its the macro running from the 'SAVE' button).
i see a few things
1. Each sheet points to the macro in sheet 1 so the assigned macro needs to be edited for each sheet
2. since there seems to be no difference between the sheets codes, why not stick it all in mudule one and call it from there instead of from each sheet?
The problem is all your save button macros are assigned to Sheet1.ConvertAllCellsToValues.
If you assign them to the sheet they are on then the macro works.
Try changing ActiveSheet to Me in the code in the worksheet modules.
Me is a reference to the worksheet the module belongs to.
If posting code please use code tags, see here.
1) Remove all scripts from individual sheets. Just leave in the "activate" script on each sheet
2) insert a regular code module (Insert > Module)
3) Paste in this one set of macros. This will be used by all sheets:
4) Remove the buttons from all the sheets except Monday (trust me)
Please Login or Register to view this content.
5) Now connect the buttons on the Monday sheet back to the remaining visible macros in the list, there should just be the one version of each now
6) Copy the 3 buttons to the other daily sheets
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi thanks all for the help problem solved :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks