If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Disable the Disable-Enable Macros windows when Open a Excel Spread Sheet with Macros

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-18-04, 12:00
Siboneis Siboneis is offline
Registered User
 
Join Date: Nov 2004
Posts: 9
Question Disable the Disable-Enable Macros windows when Open a Excel Spread Sheet with Macros

Hi,

I would like to disable or hide the screen that appear in Excel when you open a file that contains Macros ( Just for a sopecific File ).

I want to do it by Code (if is possible), or if there is any features that can change to this specific workbook.

Thanks.
Reply With Quote
  #2 (permalink)  
Old 11-18-04, 12:27
yassermh yassermh is offline
Registered User
 
Join Date: Nov 2004
Posts: 3
Hi;

you can do so without code like that:

Tools/ Options / Macro security / Security Level - choose "Low"
Reply With Quote
  #3 (permalink)  
Old 11-18-04, 12:35
Siboneis Siboneis is offline
Registered User
 
Join Date: Nov 2004
Posts: 9
Yes I know, but this applies for the Excell not for the specific Workbook.
What I want to do is just apply this for a specific Workbook.
Reply With Quote
  #4 (permalink)  
Old 11-18-04, 13:11
yassermh yassermh is offline
Registered User
 
Join Date: Nov 2004
Posts: 3
As far as I know Developer’s cannot control a user’s security settings and cannot force a user to run macros without seeing the pop-up security warning.

If you wish users to enable macros you can make the Excel file unusable unless they are enabled. All sheets can be hidden unless the user enables macros.

The best way is to use a macro to hide the important sheets when saving your file. Upon opening the file, a macro will be used to unhide these sheets. If the user disables the macros when opening the worksheet, they will not be able to view your worksheet unless they allow the macro to run.
Reply With Quote
  #5 (permalink)  
Old 11-18-04, 19:59
savbill savbill is offline
Registered User
 
Join Date: Feb 2004
Posts: 533
Hi Siboneis, there is a few of things you can do. 1. is digitally sign your macro file. There is two ways 1. have a digital signature certificate, you have to purchase a digital certificate, or 2. self sign your macro file... there is not very good documentation for the self sign method IMO. With the digital signature you aprove the macro one time, then approved files do not give a warning on subsequent use.

Not knowing what it is you are trying to occomplish makes it difficult to recomend a specific solution. Are you wanting to distribute an application or automate a process for use in your workgroup?

.
__________________
~

Bill
Reply With Quote
  #6 (permalink)  
Old 11-23-04, 13:12
Siboneis Siboneis is offline
Registered User
 
Join Date: Nov 2004
Posts: 9
Smile

Thanks to All for your answers.

An what I'm trying to do, is Just the user don't need to have the need to Enable the Macros.

This is just to make the users Lives more easy, thanks good they are users, but I have some ones that make you feel miserable; and I want avoid the "error" that the Application that I develop is not "working".

Thanks.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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