signing macros how to
I created a certificate of authority so that I can run a macro with my
high security settings. I would like to know to use the COA before I
spend 20 minutes recording a macro. Please
In the VB editor, your signature should be selectable in the Tools > Digital Signature
menu. Choose it and save.
Re-opening the file should allow you to add this signature to the "trusted source" list in
HTH. Best wishes Harald
Followup to newsgroup only please.
"Alien" <firstname.lastname@example.org]> wrote in message
news:email@example.com....Switchboard hangs when running a macro
Access 2003: I've recently discovered the Switchboard - a grand concept;
wish it wasn't so hidden...
When running a macro from a form, no problem. But when running the same
macro from the Switchboard, Access hangs. It seems to run all of the steps
in the macro, and finish, but then Access hangs. Any help would be
Thanks, Mike in Sugar Land, TX
On Mon, 30 Nov 2009 21:28:03 -0800, Switchboard newbie <Switchboard
My crystal ball is broken. Can you post some code, stripped to the
I have a file that I export to excel and I need to constantly reformat the
cells etc. I recorded a Macro for the formatting but everytime I export it
again the macro isnt there. How to I record a macro and make it available to
any document in excel?
Put the macro in PERSONAL.XLS. This hidden file gets opened every time you
"Andrew" <firstname.lastname@example.org> wrote in message
> I have a file that I export to excel and I need to constantly reformat the
> cells etc. I recorded a Macro for the formatti...Macros
I have Win Me
How do I write a simple macro?
(In Word, there is a little icon down at the bottom of the window. Double
click it and the macro recorder starts. But I cannot find an equivalent in
You say it correctrly; write a simple macro.
Outlook doesn't support recording macro's. You'll need to write VBA code in
the Visual Basic Editor
Roady [MVP] www.sparnaaij.net
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Setting Permissions on a Mailbox
-Create an Office XP CD sl...Macro Warning, But No Macros!
Running Excel 2003 SP1 on a Windows 2000 Server machine.
I have an old spreadsheet that when I open it, I get the macro warning:
"Macros are disabled because the security level is set to High and a
digitally signed Trusted Certificate is not attached to the macros. To run
the macros, change the security level to a lower setting (not recommended),
or request the macros be signed by the author using a certificate issued by
a Certificate Authority."
When I go to look for any macros in the workbook (ALT-F8), the list is
blank. Where else could there be a macro that would trigger this...Dual Monitors
We are being told by our Business Partner that spreading GP across dual
monitors can cause issues. I have a hard time believing that a microsoft
product would have issues with this. Has anyone else experienced any
problems with dual monitors?
Microsoft SBF Specialist
3/5/2008 4:51:53 PM
C Dunn wrote:
> We are being told by our Business Partner that spreading GP across
> dual monitors can cause issues. I have a hard time believing that a
> microsoft product would have issues with this. Has anyone else
...I need help with a macro please!
This bombs at the end - with a no cells were found message.
My objective is to copy a file to another file and delete the blank rows -
where company is blank. - Thanks for any help..
Here's an example of my file:
COMPANY VENDOR INV DESCRPT INV_AMT
3042 40315-3042 04/10 Sales Tax 0 0
1 3087 40315-3087 04/10 Sales Tax 806.48 806.48
3201 40315-3201 04/10 Sales Tax 0 0
1 3275 40315-3275 04/10 Sales Tax 27371.44 27371.44
1 3468 40315-3468 04/10 Sales Tax 155.62 155.62
Sheets("Inv_Load to Lawson").Select
We are migrating to SAP at the end of the year.
One of the SAP functions calls Excel and requires that Macros be enabled in
order to function.
I'm not wild about giving all my users free reign on Macros for secturity
Is there a way to enable/disable macros based on how Excel is opened?
If they open it from Windows (double-click on icon, double-click on a
spreadsheet, open from a web page, etc) have macros disabled but if it is
opened from SAP have them enabled?
Worst case, I have to enable macros across the board in Excel, is there a
Group Policy setting I can set on the...Dual monitors, dual excels
I am trying to copy and paste from one excel to another. The reason i have
two seperate excels open is because i have dual monitors and that is the
only way i know how to get excel to show up on both screens. When i try to
paste it will only paste values and it will not paste the formulas. Also
when i try to paste special it does not give me the usual paste special
menu. How can I get around this problem?
If you open one instance of excel and arrange the windows nicely, you should be
I'd start with Chip Pearson's notes:
http://cpearson.com/excel/MultipleM...Separate macros for each cell.
Ok, this is kinda difficult to explain but i will try to. I have a
workbook with 7 sheets inside. Each sheet accounts for one big category
for example Air, Noise, Pollution. Take the "Noise" active sheet for
example, it has a Row named Procedure/Training in which i want to
enable users to input info. This info is DocumentType and DocumentName.
For this purpose, i have created a user form with combo box for
DocumentType and text box for DocumentName plus "Ok","Cancel" and
"Clear Form" command buttons. The macro works fine except for it only
retur...Is there any way a macro can be created for various print area selections?
I'm looking to see if anyone knows of a way to have a macro select a
print area of a constant width (columns A thru K) but with a variable
length. Our MRP system will dump our BOM's into Excel and all of the
BOM's vary in the number of rows used. Some can be 3 pages while
others will be 15 pages. Currently we have to set up a print area to
capture the information we want printed under columns A thru K
everytime we go to print a BOM.
If you hit ctrl-end, do you go way past where you think the data should end?
If yes, you could use the techniques at...import text files in 2007 via macro
I am trying to use the macro tool to import a text file into my database. I
believe the function/action used to be called "transfer text" but I can't
seem to find in 2007. Any help would be appreciated!
Click the Show All Actions button in the Show/Hide group on the Macro
Design Tools tab.
Steve Schapel, Microsoft Access MVP
> I am trying to use the macro tool to import a text file into my database. I
> believe the function/action used to be called "transfer text" but I can't
> seem to find in 2007. Any help would be a...Dual Boot Dilema
I have a computer with space for only two hard drives. It was originally
built with Windows XP Pro (Disk 0). I added a drive (Disk 1) and loaded
Vista Ultimate on it and I do a dual boot routine as needed. At this point,
I'd like to install a new Disk 0 and build it as Windows 7 Pro. (I really
wish I could upgrade my Vista Ultimate to Win7 Pro) I guess my question is
this, if I put in a new Disk 0, boot to a DVD and build it to Win 7, what
will happen to my Disk 1? Will Windows still recognize that there are two
bootable drives and ask me which one to use? When I put a...Dual monitors
I have just started using two monitors and whatever I do, new mail messages
always open in the secondary monitor. I don't always want to have both
monitors on so how I do move the default back to the main monitor?
...255 Character Truncation, Vlookup Macro vs. Opening Workbook Macro
I just posted an entry on the microsoft.public.excel.programming forum,
but thought I'd post it here as well.
I forgot to complete the subject line on that post.
But you already have a response in .programming.
It's pretty unusual that you'd have to post to multiple forums. But if you
think you must, try to post to both at one time.
> I just posted an entry on the mi...Macro to unhide selected columns & rows
I'd like to develop a 'daily log', using one sheet for each of my 2 week pay
periods, which allows me to cross reference the particular jobs we are
working on during that time with the employees of the time. The idea being
to have a cell opened for each employees start/finish times on each job we
have on the go.
As I see it, I need to use a pair of columns for each employee, per day
(start / finish time entry) , allowing for, say 20 employees (many labourors
coming and going during the season) [ (1st 2 columns for job info) + (6 days
X 20 employees X 2 columns) + (6 days X 2 colum...Moving within a range, using a macro!!
I have a macro that says, Range("B1").Select, now I want to move within a
range automatically,and I want to be able to exit by hitting the ESC button.
The spreadsheet looks like this:
A B C D
1 Beginning 10000 10000 10000
3 Total 10000 10000 10000
There are more lines to this, but this is the general idea, I would like to
move to the right and skip a line and move down to the next empty cell, or
Why do you need to move to the cell? Selections are usually NOT ...How to activate macros on Excel 2003
After installing the new office 2003, Macros on excel don't work. How can
activated Macros on Excel to accept or create new chart? Note. Word is not
Check your Macro Security.
Tools | Macro |Security
Reduce to Medium to get the opportunity to run unsigned macros in open
workbooks. You may want to check out the Help Files About Macro Security and
Macro Security Levels.
> After installing the new office 2003, Macros on excel don't work. How can
> activated Macros on Excel to accept or create new chart? Note. Word is not
I would like to create a macro that would:
1) open IE
2) Browse to a specified website
3) Enter my user name and password
4) log in
5) go to a specified page in that website and do a search
4) open up a page listed as result of search
5) open up other specified link on page in 4) above
6) find a specified text string on that page
7) copy and paste in custom OL2002 form
I do not know VB so it is a problem.
In Excel, I cd "record" the macro manually.
How do I do it in OL 2002 WIN XP?
...Speeding up the importing of data from file
I am using the following to import binary data from a file and convert
to hexadecimal. Is there a different way to do this that would be
faster? I got list help last year to speed up my checksum routine by
putting the data into a variant array. I was able to also us it for
saving to a file too. I need some of the same magic importing data
from a file. File size can be over a meg in size and is taking minutes
Dim fs, f, ts, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(FileNa...No safe mode options with F8 on dual os dell system
I have Dell computer which i purchased from Dell with XP and Vista
installed. It is currently set to XP.
It is working fine. I am, however, trying to run a utility for AVG on
it in Safe Mode and have found out that I am having a difficult time
arriving to the Safe Mode options.
Interestingly and, most frustrating, I have found out that Dell won't
support a Dual OS system even though they are the folks who sold it to
me that way brand new! The computer is only 5 months or so old.
I try hitting the F8 immediately upon start up and I arrive at the
"choose OS" me...Mail Merge macro
How can I record a macro, with a pause, and then resume the macro to make a
mail merge. Data for merge is stored in Excel. Form is set up in Word. I
can't get the macro to record.
I'm not sure if this is true, but I think I'd record the macro while in MSWord.
I would think that it would be easier there (from someone who hasn't done this).
If you think that it might be true, you may want to post in one of the MSWord
Wonder Women wrote:
> How can I record a macro, with a pause, and then resume the macro to make a
> mail merge. Data for merge is...Using Macro how to create email link for the email addresses in a Range or Selection
Can anyone help me in writing a macro on how to create email link
for the email addresses in a Range or Selection.As i am new to excel i
am manually selecting each cell which is having email address , 'Press
F2' and then "Press ENTER".I want to automate the process and save the
If your data is in A1:A10 (say), you could add some formulas in B1:B10:
Put this in B1:
=hyperlink("mailto:" & a1,"Click to send email")
and drag down to B10
> Can anyone help me in writing a macro on how t...Use a macro to expand data series for chart?
How can I write a macro to expand each of the data series for a chart to
include one additional column?
I want it to work without knowing how many data series there are or what the
current range is. Basically, I want it to expand my ranges by one additional
column to the right.
...Macro to align and compare multiple rows and columns
Thanks in advance to those who would spend some time of their's to help me.
I am looking for a macro which can align and compare multiple columns, each
of several rows of data. Some rows(text in the cells) of each column are
identical with the next, which mean while "Apples" is present in all
columns,"bananas" in columns 2, 6, 13 and "oranges" is present only in
column 1,5, 7 and 11.....Then the formatted list should show "apples"
aligned A2, B2, C2, D2.......X2 so on,"bananas" in B4, F4,M4 while
"Oranges" will be shown onl...