Hello to All Forum Members,
I am using Windows 93 and have searched everywhere but cannot find any sample code of how to write a macro that would do any of the following:
1. When opening Excel a commandbutton with no caption must appear.
2. The user then enters a caption on the command button - to indicate to the
command button what the user want the macro to do.
For example:
A. Say the user enters on the Button create "Stock Sheet" - The macro must create the necessary Sheets with complete detail, controls, checks and so on.
B. Create a "Parts List"
C. Production Scheduling Forecast
D. Invoicing, Timesheet, Etc. Etc.
O yes, any WorkBook should have no more or less than 401 Sheets, each with the appropiate tab color, conditional formatting and preset print ranges.
I really thought that Excel was such a fantastic pliable tool with almost no limits, and yet
nobody seems to have this readily available for me to use.
Could anyone of you please be so kind as to write me such a Macro? People I can immediately think of to do it for me would inter alia be, Leith Ross, Daddy Long Legs, SHG, NBVC, Andy Pope and/or anyone else.
I do need it quite urgent please.
Thank you!
Bookmarks