PC Review


Reply
 
 
=?Utf-8?B?QW1iZXI=?=
Guest
Posts: n/a
 
      1st Oct 2007
I have added a checkbox to a form and when I send the document to a coworker,
she can perform all tasks but the checkbox. When I open the file, it asks to
enable macros but when she opens it, the system does not ask.

How can I send I file that has a macro(checkbox) in it and have others be
able to use it?????

Thanks for a ny help that comes my way.'
Amber
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QmVhcg==?=
Guest
Posts: n/a
 
      1st Oct 2007
Amber:

Macros can be stored in several different places. If you haven't spedified
where you wanted to save your macros, Word probably saved them in your
Normal.dot file.

The "ideal" way to share macros is to put them in a document template, or a
global add-in tools template. It's probably not a great idea to store macros
in a document, though it can be done.

If you just want to send a single file containing code to another user, you
can copy it using the VBE (Alt + F11) or Word's Organizer function.

Bear
--
Windows XP, Word 2000


 
Reply With Quote
 
=?Utf-8?B?QW1iZXI=?=
Guest
Posts: n/a
 
      1st Oct 2007
Bear,

Thanks for the information but another question.

I did save it in the DOT file. When I open it, it asks me to"enable"
macros. Once I have sent the DOT file via email and the others open it, it
does not ask....

What have a done incorrectly????

"Bear" wrote:

> Amber:
>
> Macros can be stored in several different places. If you haven't spedified
> where you wanted to save your macros, Word probably saved them in your
> Normal.dot file.
>
> The "ideal" way to share macros is to put them in a document template, or a
> global add-in tools template. It's probably not a great idea to store macros
> in a document, though it can be done.
>
> If you just want to send a single file containing code to another user, you
> can copy it using the VBE (Alt + F11) or Word's Organizer function.
>
> Bear
> --
> Windows XP, Word 2000
>
>

 
Reply With Quote
 
=?Utf-8?B?QmVhcg==?=
Guest
Posts: n/a
 
      1st Oct 2007
Amber:

There are two reasons why you might get that message while others do not.

1. Your macro security settings are higher than those of others.

2. Despite what you think, there is no code stored in the file you're sending.

On the target user's machine, open the DOT file you've sent and verify that
the code is in place.

If the code is there, run it from the VBE using F8 or F5. If it works, then
perhaps you've customized a keyboard shortcut, but saved that customization
in your Normal.dot, rather than in the DOT file you're sending.

Bear

--
Windows XP, Word 2000

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CheckBoxes =?Utf-8?B?YXdhY2g=?= Microsoft Access Forms 1 15th Jun 2007 01:53 AM
checkboxes =?Utf-8?B?eXZsdA==?= Microsoft Frontpage 2 27th Mar 2005 06:16 PM
Re: Checkboxes and Other Bill Renaud Microsoft Excel Programming 0 5th Apr 2004 05:09 AM
Checkboxes =?Utf-8?B?Sm9zaCBN?= Microsoft Access Getting Started 8 22nd Jan 2004 01:16 PM
checkboxes RICHARD Microsoft Excel Worksheet Functions 1 8th Jul 2003 05:00 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:11 PM.