Suppress Read Only Prompt

[neilby]

Dear all,

I have a workbook that contains macros and this has been passed out to the user community by being saved in the XLSTART folder (as a hidden file) so when they open excel it is opened automatically in the background and they can use the macros within.

This means that a number of users could have this file open at the same time

Each user (after the first) receives the quite annoying popup window asking the user whether to open as read only, notify or cancel. They also receive the message if for example a 3rd party software is exporting to excel causing a new session to open.

A normal user will never be expected to make changes to the macro file so therefore Read Only is always the answer to this question.

I have attempted saving the macro file in windows explorer with "read-only recommended" but this just leads to another, just as annoying message being displayed.
A normal user will never be expected to make changes to the macro file.

What I am looking for is a bit of VBA that I can place in the Macros workbook that will, upon excel session start, select the Read-only option relating to the Macros workbook AND open the workbook without the user having to click any message boxes.
Path = drive\folder\folder\folder\Macros.xlsm

I have found similar code relating to Close with/without Save so I assume it is possible.

Thanks in advance

 

[RoryA]

I would suggest you make the workbook into an add-in. You'll need a menu system to run its macros but you won't get any prompts about read-only etc.

 

[Kyle123]

Why don't you just save it as an addin?

 

[neilby]

I would suggest you make the workbook into an add-in. You'll need a menu system to run its macros but you won't get any prompts about read-only etc.

Thanks to both of you for this suggestion.

The macros in this workbook already have a menu system for easy of use AND are accessed by users via the Excel AddIns toolbar so not sure what I must be missing in the setup to avoid the problem as you both seem to think this is the way to go.

Any thoughts on obvious setup mistakes that could result in this problem?

regards

 

[RoryA]

You need to save it as a .xlam file rather than xlsm

 

[neilby]

You need to save it as a .xlam file rather than xlsm

Well, what do you know....never been that far down the excel file save-as list . I'll give it a go.

Knew it had to be something obvious, to someone else.


thanks