Shortcut to save as xlsb2/18/2023 The sheet-naming part didn't work (was in red when I pasted it in), but there's also a little more involved in the whole naming thing. I'd like for them to be able to just use this.Īny assistance would be greatly appreciated, with sincere thanks in advance. Can I distribute this so that barely-computer-literate folks don't have to create their own self-signed certificates, install them and sign the sheet with them? Once they see warning boxes pop up my phone lights up like a Christmas tree. Basically a "do you really want to do this" last-chance box. Two "would be nice to have" features are:Ī) Have this called by a button that can be placed on one worksheet but perform the maintenance on anotherī) Present an information box with text that will ask the user to confirm that he/she is finished with the previous month's report and acknowledging that if he/she proceeds in running the macro the changes made will be permanent. Typically the worksheets will be named like this: "Letter-A February 2011," I would like for the user to be able to enter any name he/she wants, but if possible, to suggest the next month/year as the default.ģ) Perform the actual save-as (so far this has eluded me.it looks like it saves the file but it doesn't)Ĥ) Close the old month, open the newly-created month then run the maintenance routine and pop up a dialog saying the new month's sheet has been created, and it can now be safely closed. I have a recorded working macro to do some simple maintenance tasks for the workbook but what I need is the code necessary to do the following simple steps before the actual maintenance tasks are started.ġ) Save the current document with it's current name (easy enough, I suppose).Ģ) Save As, then give the user the option to select the path and filename. I'm doing this in Excel 2007 but most of our guys and gals are working with Excel 2003 or earlier. I'm modifying a master workbook for my organization that will be distributed to about 20 different users, mostly senior-citizens with minimal computer expertise who do volunteer work. I have a couple of questions regarding macros with which I hope someone here can kindly assist.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |