Hi...

I have 15 sheets containing loads of info which is important. When I want my
staff to open this file they must enable macros so that the security of my
data is safe. Therefore, when they open the excel file, if they diable macros
all they have access to is a sheet that says you didn't load macros, close
the file, reopen and enable macros. This way they can have access to what I
want them too.

So the question is, can I appear to have an empty excel file, until macros
are enabled?

Cheers

G

Is the file READ - ONLY by your stafff. If so you can hide all the pages
when you store the file. Then have an On On Open event macro that unhides
the sheets. If macros are disabled the macro that unhides the sheets will
not work.

"Gordon" wrote:

Hi...

I have 15 sheets containing loads of info which is important. When I want my
staff to open this file they must enable macros so that the security of my
data is safe. Therefore, when they open the excel file, if they diable macros
all they have access to is a sheet that says you didn't load macros, close
the file, reopen and enable macros. This way they can have access to what I
want them too.

So the question is, can I appear to have an empty excel file, until macros
are enabled?

Cheers

G

Hi Joel...

Is there any code around that can help me here. I've been playing with an
workbook_open idea in the workbook, but I think it clashes with an auto_open
macro in module 1. Also, I get error messages regarding workbook_beforeclose
which I think clashes with an aut_close macro also in module 1.

I know what I want to do but just can't make it happen.

Any help appreciated!!!

G

"Joel" wrote:

Is the file READ - ONLY by your stafff. If so you can hide all the pages
when you store the file. Then have an On On Open event macro that unhides
the sheets. If macros are disabled the macro that unhides the sheets will
not work.

"Gordon" wrote:

Hi...

I have 15 sheets containing loads of info which is important. When I want my
staff to open this file they must enable macros so that the security of my
data is safe. Therefore, when they open the excel file, if they diable macros
all they have access to is a sheet that says you didn't load macros, close
the file, reopen and enable macros. This way they can have access to what I
want them too.

So the question is, can I appear to have an empty excel file, until macros
are enabled?

Cheers

G

auto_open is an older style macro from excel 97 days. You should convert it
to a worbook_Open by just changing the header line and making sure it works.
Then add you changes. Try your code again and if you need help let me know.
but if you already have code I usually prefer to modify your code then to
start my own. It is going to be easier for you to maintain code that you
understand rather than learn somebody elses code.

"Gordon" wrote:

Hi Joel...

Is there any code around that can help me here. I've been playing with an
workbook_open idea in the workbook, but I think it clashes with an auto_open
macro in module 1. Also, I get error messages regarding workbook_beforeclose
which I think clashes with an aut_close macro also in module 1.

I know what I want to do but just can't make it happen.

Any help appreciated!!!

G

"Joel" wrote:

Is the file READ - ONLY by your stafff. If so you can hide all the pages
when you store the file. Then have an On On Open event macro that unhides
the sheets. If macros are disabled the macro that unhides the sheets will
not work.

"Gordon" wrote:

Hi...

I have 15 sheets containing loads of info which is important. When I want my
staff to open this file they must enable macros so that the security of my
data is safe. Therefore, when they open the excel file, if they diable macros
all they have access to is a sheet that says you didn't load macros, close
the file, reopen and enable macros. This way they can have access to what I
want them too.

So the question is, can I appear to have an empty excel file, until macros
are enabled?

Cheers

G