I have a file that has a password on it. To save the file without a password I click save as and then next to save choose tools, general options, delete the password that's already there and then save the workbook.
What's the VBA code to do the above so that the file gets saved without a...
Hi Guys,
I have a workbook that I have password encrypted. (I know the password!)
I have a vba module that strips out the sheets with the data I want to keep private so that the remainder can be shared with others. The problem is that when this new version saves it still has the password...
Hi,
I created a debtors reporting system at work to be used by several users across the company (probably about 30 people) and saved it on the shared work network. I locked each sheet individually and left certain cells unlocked with data validation set up for those cells. The purpose of...
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.