Enable Macro Message

How can you disable the message upon opening a file without setting the 
security to lowest? I do not want to give the user options to disable or 
enable the macro.

Is that possible?

Thanks.
0
Rook (11)
9/5/2006 4:15:01 AM
excel 39879 articles. 2 followers. Follow

1 Replies
458 Views

Similar Articles

[PageSpeed] 13

This is a user's security setting--not a developer's security setting.

If you could change it, it wouldn't be of much use to the user, huh?

Rook wrote:
> 
> How can you disable the message upon opening a file without setting the
> security to lowest? I do not want to give the user options to disable or
> enable the macro.
> 
> Is that possible?
> 
> Thanks.

-- 

Dave Peterson
0
petersod (12005)
9/5/2006 12:20:33 PM
Reply:

Similar Artilces:

Creating a Macro to Compact all .pst files
Can someone point me to an example of a macro that would: Go through all open .pst files (I have about 20 pst files) Empty the trash in each .pst file Compact each .pst file I'm using Outlook XP on Windows XP Pro SP1. Outlook XP allegedly compacts automagically, though I have yet to observe it doing so. In any case, help on writing such a macro would be appreciated. Thanks in advance. Compacting a PST file is not something you can control from code. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginners Guide to Microsoft Office Outlook 2003 Reminder ...

copy and overwrite ??? -can't get rid og duplicate messages !!!
Hey you wise people ! HOW can I make Outlook overwrite identical messages when copying a large amount of messages from one folder to another. I have 2 folders that are not 100% the same and would like to merge theese into one -without getting duplicate messages. It would seem to me that this should be a BASIC thing to do (like when you copy between folders in Windows, it always asks you if you want to overwrite...) but Outlook just copies everything without asking and i end up having 100'dreds of duplicate messages. I'm frustrated........- please help. Claus, DK ...

Exchange 5.5 message size limit...Still to this day haven't been given a straight answer
My setup: Exchange 5.5 service pack 4, running on NT 4.0 server, all lastest SPs. I get complaints often when outsiders try to email my users a large file... NONE of my mailboxes have limits on them. I think I heard the true limit was 2.6 megs... Just to test it, I sent myself from my personal email accout to my work account, a 1.06meg file. It got through. Then I tried to sent myself a 3.5 meg file. It did not get through. Are there some bases I am not covering? Thans in advance! Jazz Mann did you check the ims settings? "jbraly@gmail.com" wrote: > My setup: > Exchan...

Copy and paste within a macro
I've created macro to copy the value of one field and I want it to paste this value into another field. However, it's pasting in the value that's stored in the macro. I tried deleting the TypeTo line after the cmdEditPaste line but now nothing gets pasted. How do I get it to paste in what gets copied each time (from the clipboard)? Elaine, Try doing an 'Edit Select All' first and then a 'Copy' and then an 'Edit Select All' and then 'Paste'. Remove the TypeTo after the paste. For instance, on the GL trx entry window if you wanted t...

error message 12-03-09
Every time I try to open a url from an email message, I get an error message telling me that window can not open it. But if I click off the error message and try to open the url again, it will open. Any body know why?? Thanks Actually the error message states that "Windows can not find the URL." thanks, dljfnp "dljfnp" wrote: > Every time I try to open a url from an email message, I get an error message > telling me that window can not open it. But if I click off the error message > and try to open the url again, it will open. Any body know why?? ...

browser-view instead of message preview
I can't get the list of messages and de preview-pane in outlook 2003. I get a browser window (google) instead. Pressing inbox / outbox ... gets me the right view for about half a second. Then the browser-view re-appears. Any suggestion ? thanks, Jan ...

Outlook shows all messages as "attachment"
Hi, I have an problem, that Outlook Express shows all the messages as attachement. Nothing else on preview panel, but "ATT00013.TXT" type attachements. Even if the email is surely text-only, this happens. I've got no idea, how to fix this. Anyone got any ideas? ...

Error message consistently shows and shuts down entourage
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: Exchange I get the following error message when I open entourage and then entourage closes itself down: Microsoft Sync Services has encountered a problem and needs to close. We are sorry for the inconvenience." Clicking the "More Information" button gives me the information I'll paste in at the end of this email. Please help me -- I googled the error but the answers were too techy for me to figure out. Right now I can't read/send emails or schedule meetings. Than...

Cannot find macro
I was alerted when I was opening an excel sheet that there were macros. The file was originally created by another person. However, when I went in and tried to delete them, I did not see any macro listed. Where can I find these macros? New users wrote: > I was alerted when I was opening an excel sheet that there were macros. The > file was originally created by another person. However, when I went in and > tried to delete them, I did not see any macro listed. Where can I find these > macros? See the messages with subject, macro warning. They solved this problem fo...

how to alter the date within a macro
Hello, I was trying to create an archive function on a workbook. I have a formula throughout the workbook that is based on the current date using NOW(). I went in a recorded a macro of replacing the NOW() with last years date. How can I set this so that I can have the user push a button to archive the sheet and have the year based on the current date? I want to change the replacement to an argument that gives the year -1 at the time of clicking the archive button. The current recorded code follows. Thank You LWhite Cells.Replace What:="NOW()", Replacement:="Date (...

automation, macros ...
I'm ok with xcel macros and vba and would like to jump into outlook automation (fill in the greetings based on address, fill in signature ...) Where is the 101 stuff? Where's a good place to see examples? A good FAQ. Thank you. You might start at http://www.outlookcode.com/article.aspx?ID=40 -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "oldyork90" wrote: > I'm ok with xcel macros and vba and would like to jump into outlook > au...

Publisher 2000 Error Message when saving work
I have been using this program to publish a club newsletter for approz 1 year. Starting tonight the program will no longer let me save my changes to a file - and gives an error message. I have tried reloading and restarting the program. Have also used the command under Help to repair the file. Nothing is working. Any suggestions? I appreciate the help! Are you using the same Newsletter over and over? Bad idea... What is the exact error? How to troubleshoot a damaged publication in Publisher http://support.microsoft.com/default.aspx?scid=kb;en-us;198256 -- Mary Sauer MSFT MVP h...

Blank Message Body in OWA
After bringing the patches up to date on our Exchange Server, we are seeing blank message bodies when viewed with OWA. The text only appears when you do a Reply or Forward on the message. Running on NT4 SP6, Exchange 5.5 SP4 Have looked at KB314532 but problem still persists. Any ideas. TIA Roy. ...

Display a new notofication message when new email arrives
Hello the "display new notofication messasge when new email arrives" option does not work on clients computer. Tool>Options>email options. Any ideas??? OS Win XP SP1 Outlook 2002 SP2 Both are English versions. Thanks Nevs. ...

how do I disable the EULA message each time an Office app opens
Each time I open an office app,ie WORD, Excel; the EULA message to Accept or Decline appears and needs to be answered before the app opens. How does one stop this from coming up each time? ...

"Delivery Status Notification (Relay)" messages
Hi everybody, When sending mails to external recipients I forward all SMTP mails via an SMTP connector to a smart host. When a user sets "delivery receipt requested" in Outlook and sends a mail to an not existing external recipient (e.g. domain does not exist) the Exchange bridgehead server sends a "Delivery Status Notification (Relay)" message to the user. In the same second our SMTP smart hosts sends an NDR e.g. that the domain does not exist. Is there any way to tell Exchange not to send a Relay delivery status notficiation when sending mails via smart host to e...

Outlook Macro using SendKeys in OL2007...
Hi, We have a macro that worked great until installed with OL2007. It sends some keys to a custom form to check a few checkboxes, etc. We did add it to the toolbar so we could click it, but it doesn't send the keys any longer. Any ideas? Thanks, Alan http://www.sadevelopment.com Partition Boot Manager and Large Drive Tools utilities! SendKeys is never a good programming solution. In this case, the = keystrokes are probably different. But you really you should be setting = property values using the Outlook object model instead.=20 FYI, there is a newsgroup specifically for gene...

Exchange 2003 Message Tracking #2
When I go into the message tracking center and select the exchange server name of the server that has the mailbox that i'm trying to track message for, it renames itself to another exchange server name. Message tracking is enabled on the Exchange server that I want to search. The logs are in place. The servername.log share is in place and the permissions are correct. The server that I am trying to track is a cluster, that is the only thing that I can think of. I seem to recall having tracked messages in the past and can't think of anything that has changed. I've tried ...

"Too many fields defined" error message
I received a "Too many fields defined" error message when importing an Excel 97 spreadsheet into SQL Server 2000. There are 256 columns in the Excel 97 spreadsheet, all containing data. How do I correct this in Excel 97? It's a bug. There's a bit of information in the following MSKB article: BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns http://support.microsoft.com/default.aspx?id=207446 Godzilla wrote: > I received a "Too many fields defined" error message when > importing an Excel 97 spreadsheet into SQL Server 2000. > There ...

can't delete messages #4
When I try to delete a message in the inbox I get a message 'The meswsaging interface returned an unknown message. If problem persists restart outlook'. Restarting dooes not solve the problem. I also reinstalled outlook over the existing program without success. Any advise? Peter Z <anonymous@discussions.microsoft.com> wrote: > When I try to delete a message in the inbox I get a > message 'The meswsaging interface returned an unknown > message. If problem persists restart outlook'. Restarting > dooes not solve the problem. I also reinstalled outlook >...

I dont want to erase my messages on the server
I want to keep a copy of all my messages on the server and when I delete them from my windows mail it dissapears from my gmail account, how can I change that? Tools | Accounts | Mail | Properties | Advanced - Check: Leave a copy of messages on the server. -- Bruce Hagen MS-MVP [Mail] Imperial Beach, CA "AlexMV" <AlexMV@discussions.microsoft.com> wrote in message news:F6FDC7EA-F8A7-4819-8E38-F924A2B3F78D@microsoft.com... >I want to keep a copy of all my messages on the server and when I delete >them > from my windows ma...

wildcard in filenames in macro
Excel 3007. I have a n application where I have several workbooks open at the same time all controled from a "Main Menu" workbook. The filenames are standard and always the same excepting for the first character which varies. I am trying to write a macro's to 1) switch between the windows and 2) to close the files when closing the Main Menu workbook. Is there a way to reference the files within the macro no matter what the first character may be in each case? Any help or suggestion is greatly appreciated. OK, OK!! Should be 2007! "Wes_A" wrote: > E...

How to -> Start Excel from command line and run a macro
I have an Excel spreadsheet with a macro. What I want to do is to be able to start this spreadsheet via a BAT file(mainly to schedule the running). But the kicker is to run the Macro. I realize I may have to disable the security to get passed the ENABLE/DISABLE prompt..or is there another way to handle that too? I have gotten close by getting EXCEL to load my spreadsheet but I am stuck on the "right way" to handle the prompt and autostart the macro. Any help will be appreciated. -- Mickey A Assuming that you have Microsoft Excel 2003, this might help: Assistance > E...

Can't change New Message Window Size
I have Windows Live Mail set to reduce the overall size. I did have New Message reduced so it doesn't take up the whole screen. Somehow that got changed and now it fills the whole page and decreasing the New Message window box does nothing. > Somehow that got changed and now it fills the whole page and decreasing > the New Message window box does nothing. Annoying isn't it? I always try to keep one spare open in case that happens. Then all I need to do is close the problem window, close the spare, and hope that the next window which opens will be in the...

"Get/Change" Error message Safe Pay
We recently completed upgrading a customer from version 8 to version 10. We get the following error message when we reload transactions in safe pay. "A get/change first operation on table "ME_Void_Checks" failed accessing SQL data. Any help appreciated. Thanks Russ ...