Custom Toolbars with Macros LAST STAND!

Ron Walker

New Member
Sep 6, 2005
I have been sifting thru the posts of thousands for a month and I have seen a lot of stuff in regards to the "Custom Toolbars" and "Macros" that are "Attached" to them. A lot of useful information has been gathered from this experience, as well as a lot of new questions arise as the first one is you might say. Postings will show that I am not alone in saying that there are some serious questions that need to be aired out on the above subject, and it would be nice if we could all work together for a moment and assemble(in one place) the wealth of information that has been scattered across many postings(in pieces at that). I will list the questions I currently have on the topic and hope to get good participation as I will also be adding anything I can to this posting as questions progress.
1. Custom Toolbars and Macros need to be Attached to the Workbook each time they have been modified. YES
2. Toolbars need to be deleted "UponClosing" in order for revisions to be installed upon re-opening. YES
3. Toolbars can be "Enabled", "Disabled","Visible", or "Deleted" using Visual Basic code. YES
4. Toolbars are stored in .XLM format, not in .XLS. YES
5. Toolbars can be on top,bottom,left or right of screen. YES
6. Workbooks with "Custom Toolbars" that have been "SavedAs" and closed can be re-opened without any ill-effect on either workbook. ?
7. Macros as well will not be "renamed" and fail to function due to "SaveAs." ?

Thank you all for your input on this posting and I hope to share with you soon......Ron Walker :biggrin:

Forum statistics

Latest member
Winfield Ullrich I

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...