If you want to add Button on an excel spreadsheet you have two choice
1) Active-x buttons
2) Form buttons
I you plan to duplicate a spreadsheet whic contains buttons using VBA Code, than you must use
Form buttons not Active-x ones.
If you use Active-x buttions you might get a VBA run time errors, which now on top of my head I don't rememeber.
So the tip here is
Use Form buttons if you plan to duplicat using VBA code to duplicate excel spread-sheets that contains them.
Monday, October 15, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment