Saving Excel Spreadsheet as Read Only

  Desert Andy 11:22 AM 29 Jan 13
Locked

Hi

I have put a control button using vb code to save a workbook, however I am having a few problems.

I open workbook B using vb code in workbook A, I make a couple of changes and then save it, if I shut down all workbooks, workbook B is saved correctly.

However, if I reopen Workbook B without having shut down Workbook A, it tells me that Workbook B is read only, and I can't modify it.

I can't understand what is happening, are there any ideas how I solve this problem, is there a way of saving a workbook making sure that it is not read only.

Many thanks

  difarn 11:40 AM 29 Jan 13

Try typing the name of your spreadsheet into windows explorer then right clicking on it, click on properties to check that read only has not been ticked.

  Desert Andy 11:53 AM 29 Jan 13

Amazingly the box is not ticked. I really don't understand what is happening.

  tasslehoff burrfoot 21:20 PM 29 Jan 13

Can you post your code?

Advertisement

This thread is now locked and can not be replied to.

How to get Windows 10 now: how to download and install Windows 10 even if GWX.exe is missing

1995-2015: How technology has changed the world in 20 years

Nokia rolls out spherical camera for virtual reality apps

7 best iPhone web browser apps: Why Safari for iOS is still a better option than Chrome, Dolphin,…