Disabling disable macros
 

Hi,
I wrote macros in my excel sheet. If user clicks on disable macro, my excel
sheet should not be opened. Any help.
Regards,
Ram

Disabling disable macros
 

most usual solution

have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS
WORKBOOK TO RUN." and your other worksheets hidden. If they click enble
macros use code to have that sheet hidden and all other appear. but if they
click disable only that sheet is visible. Be sure to reverse the process on
save or close.
Ben

--
When you lose your mind, you free your life.


"Ram" wrote:

Hi,
I wrote macros in my excel sheet. If user clicks on disable macro, my excel
sheet should not be opened. Any help.
Regards,
Ram

Disabling disable macros
 

Hi Ben,
Thank you very much. But when i make the sheets visible, user can save the
EXCEL and he will have a copy of visible sheets.
Thanks and Regards,
Ram

"ben" wrote:

most usual solution

have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS
WORKBOOK TO RUN." and your other worksheets hidden. If they click enble
macros use code to have that sheet hidden and all other appear. but if they
click disable only that sheet is visible. Be sure to reverse the process on
save or close.
Ben

--
When you lose your mind, you free your life.


"Ram" wrote:

Hi,
I wrote macros in my excel sheet. If user clicks on disable macro, my excel
sheet should not be opened. Any help.
Regards,
Ram

Disabling disable macros
 

you can add code to the

sub workbook_beforesave(byval cancel as boolean)
'make sheets invisible here again.

end sub

put that in your workbook module


--
When you lose your mind, you free your life.


"Ram" wrote:

Hi Ben,
Thank you very much. But when i make the sheets visible, user can save the
EXCEL and he will have a copy of visible sheets.
Thanks and Regards,
Ram

"ben" wrote:

most usual solution

have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS
WORKBOOK TO RUN." and your other worksheets hidden. If they click enble
macros use code to have that sheet hidden and all other appear. but if they
click disable only that sheet is visible. Be sure to reverse the process on
save or close.
Ben

--
When you lose your mind, you free your life.


"Ram" wrote:

Hi,
I wrote macros in my excel sheet. If user clicks on disable macro, my excel
sheet should not be opened. Any help.
Regards,
Ram

Disabling disable macros
 

Hi Ben,
Thanks . It works.
Regards,
Ram

"ben" wrote:

you can add code to the

sub workbook_beforesave(byval cancel as boolean)
'make sheets invisible here again.

end sub

put that in your workbook module


--
When you lose your mind, you free your life.


"Ram" wrote:

Hi Ben,
Thank you very much. But when i make the sheets visible, user can save the
EXCEL and he will have a copy of visible sheets.
Thanks and Regards,
Ram

"ben" wrote:

most usual solution

have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS
WORKBOOK TO RUN." and your other worksheets hidden. If they click enble
macros use code to have that sheet hidden and all other appear. but if they
click disable only that sheet is visible. Be sure to reverse the process on
save or close.
Ben

--
When you lose your mind, you free your life.


"Ram" wrote:

Hi,
I wrote macros in my excel sheet. If user clicks on disable macro, my excel
sheet should not be opened. Any help.
Regards,
Ram

Disabling disable macros
 

sub workbook_beforesave(byval cancel as boolean)

That code won't compile, because it doesn't match teh BeforeSave
declaration.

Use
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel
As Boolean)

instead.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"ben" (remove this if mailing direct) wrote
in message
...
you can add code to the

sub workbook_beforesave(byval cancel as boolean)
'make sheets invisible here again.

end sub

put that in your workbook module


--
When you lose your mind, you free your life.


"Ram" wrote:

Hi Ben,
Thank you very much. But when i make the sheets visible, user
can save the
EXCEL and he will have a copy of visible sheets.
Thanks and Regards,
Ram

"ben" wrote:

most usual solution

have one extra sheet that declares loudly "MACROS MUST BE
ENABLED FOR THIS
WORKBOOK TO RUN." and your other worksheets hidden. If they
click enble
macros use code to have that sheet hidden and all other
appear. but if they
click disable only that sheet is visible. Be sure to reverse
the process on
save or close.
Ben

--
When you lose your mind, you free your life.


"Ram" wrote:

Hi,
I wrote macros in my excel sheet. If user clicks on
disable macro, my excel
sheet should not be opened. Any help.
Regards,
Ram