Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
kcdonaldson
 
Posts: n/a
Default How can force enable macros to be able to open my workbook?

I would like to be able to force employees to enable macros for a certain
workbook or it will not let them open the workbook. And maybe put a password
on it so if i would like to modify the workbook without the macros enabled.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas
 
Posts: n/a
Default How can force enable macros to be able to open my workbook?

set up the workbook so that the only sheet showing is one with a message
which says "You must enable macros for this workbook to work." in a large
obvious font. Have the workbook password protected and all sheets
veryhidden.
In the workbook_Open event, hid that message-sheet & display the sheets
which you'd need to have visible.
So, if the user disables macros all they see is a sheet with a message on
it; If the open it with macros enabled, the Open event will kick in and make
the workbook work the way you want.
Bob Umlas
Excel MVP

"kcdonaldson" wrote in message
...
I would like to be able to force employees to enable macros for a certain
workbook or it will not let them open the workbook. And maybe put a

password
on it so if i would like to modify the workbook without the macros

enabled.


  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How can force enable macros to be able to open my workbook?

Give them a helper workbook that opens the real workbook.

The helper workbook would have a macro that opens the real workbook. If macros
are disabled, then the helper workbook's code won't run--and the real workbook
won't be opened.

The helper workbook would have code that looks like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:=thisworkbook.path & "\book2.xls", _
Password:="hithere"
ThisWorkbook.Close savechanges:=False
End Sub

Remember to protect that project so that users can't snoop and find the password
to open.

(That said, that kind of protection is pretty weak and can be broken by any user
who is dedicated.)

kcdonaldson wrote:

I would like to be able to force employees to enable macros for a certain
workbook or it will not let them open the workbook. And maybe put a password
on it so if i would like to modify the workbook without the macros enabled.


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
Hernandez, Roberto
 
Posts: n/a
Default How can force enable macros to be able to open my workbook?

"kcdonaldson" escribió en el mensaje
...
I would like to be able to force employees to enable macros for a certain
workbook or it will not let them open the workbook. And maybe put a
password
on it so if i would like to modify the workbook without the macros
enabled.



Regards!

You can´t do it directly with Excel.
You need to configure book to hide useful sheets when closing, an unhidding
it when a correct password is typed when promt...

For example, when you close your book (in the beforeclose event) you can
hide your sheets with a set of lines like this one:

Worksheets("Usefulsheet").Visible = xlSheetVeryHidden
Worksheets("NonUsefulSheet").Visible = xlSheetVisible

and in the Workbook_Open event something like:

Worksheets("Usefulsheet").Visible = xlSheetVisible
Worksheets("NonUsefulSheet").Visible = xlSheetVeryHidden

So, if user disables macros at startup, will only see a nonuseful sheet,
whit a sentence like: "you disabled macros when opening this book, close it
and able macros when promt..."

It's an easy but not 100% secure method...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting multiple sheet tabs and open another workbook Bannor Excel Discussion (Misc queries) 5 November 25th 05 03:38 AM
How do I save a workbook as a new workbook by using macros? KingKarl Excel Discussion (Misc queries) 4 November 10th 05 09:34 AM
Enable macros? Steve Excel Worksheet Functions 2 October 14th 05 04:17 PM
can't open excel workbook gerry405 New Users to Excel 1 October 8th 05 12:26 PM
Force content in closed workbook Nigel Excel Discussion (Misc queries) 1 May 16th 05 06:01 PM


All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"