Hi all,
I am using a standard code to by pass the save changes prompt but instead of saving automatically and closing, the save prompt shows and when I select Yes, its prompts again and again. By only selecting Cancel will it disappear.
Any suggestions how to fix this? Or what may cause this...
Hi all,
I am relatively new to VBA and am trying to learn it's limitations.
I have managed to create a user form that creates a new tab with the name entered in the user form text box.
On this new tab, is there a way using VBA to have it equal to the values and formatting of an other tab at...
Pivot chart formatting changes (title position, size of legend box, positioning of values on pie chart) - won't save :(
Workbook is password protected. 3 Pivot charts created off 1 data set. Excel 2013.
Please help! :eeek:
Thank you!
I have a problem that I've spent way too much time trying to figure out! I need to SUM a series of named ranges. When using the range names in the SUM formula, instead of A1 cell references, Excel prompts to save changes when exiting even though no changes have been made to the workbook...
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.