We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Saving Excel Spreadsheet as Read Only


Desert Andy

Likes # 0

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

Like this post
difarn

Likes # 0

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.

Like this post
Desert Andy

Likes # 0

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

Like this post
tasslehoff burrfoot

Likes # 0

Can you post your code?

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Acer Aspire R11 review: Hands-on with the 360 laptop and tablet convertible

IDG UK Sites

Apple Watch release day: Twitter reacts

IDG UK Sites

See how Framestore created a shape-shifting, oil and metal based creature for Shell

IDG UK Sites

Apple Watch buying guide, price list & where to buy today: Which Apple Watch model, size, material,?......