Custom Toolbars with Macros LAST STAND!

Ron Walker

New Member
Joined
Sep 6, 2005
Messages
6
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 solved........progressive 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:
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,214,978
Messages
6,122,549
Members
449,089
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top