I am copying and pasting data using a macro. After the data is successfully
copied and pasted i get a message:
Large amounts of data are on the clipboard do you want to be able to paste
this data into a program later?

If I have two excel files (both with VBA applications) open and I am running
VBA application from one of them, when I try to do “User1.show”, it fails.  I
get a “Run Time error 9.  Subscript out of range.”
However if I close the application I am not using at the moment the

Anyone found a quick way to navigate back to the workbook you were just
working in without going up to the 'Window' menu and hunting for it in the
list of open workbooks..?
I'm thinking of a piece of VBA or a keyboard shortcut?

I found a script in an old EEE newsletter on j-walk.com that disables cut and paste in a workbook/sheet. This is something that I need desperately as my staff insist on using cut and paste in their timesheets and it is driving me bereft. If I had a donut for every time I'd told ...

from accounts report i get +ve values ends with Dr & -ve values ends with
Cr.
Can i number format the column so that +ve values display as numbers (
without end Dr ) & -ve values as -numbers ( without end Cr )

Not being familiar with VBA ,I've created a new single sheet Workbook;
copied the data from one worksheet; set column widths to match original
and created the print setup all, using the Macro Recorder.
My question is this, because I used the recorder (I assume) the new

Hi all,
I am trying to format a number that can be in the range + or - xxxxxx.
I have formatted such that it reads:
[<1000000]0.00,"Kbps";[>=1000000]0.00,,"Mbps";General

Is there an easy way to find the number of a letter in the alphabet; e.g.
that "E" is the fifth letter?
Thanks.
Bill

I have a right click menu macros built in to a template.  After creating a
new workbook (with this template), if I create a new workbook using the same
template, Excel wants to execute the right click macro from the 1st workbook
(even if the 1st workbook is closed).  Whether the ...

is there any way to show date automatically when i open my excel spreadsheet?
for instance, if i exported a file that has 100 rows and 5 columns and save
it as *.xls file. When i open the file it will show current date in a new
columns? is it possible?

After running a macro I want no selected cell(s) in my sheet. Does someone
know how to do that?
Gert-Jan

I'm new to the forum and also to excel macros - so what you'll see
below is likely an ugly hack.
My question is (I hope) simple - I have a userform with many
comboboxes.

hi
many a times we come across a msgbox
with check box on it labeled "do not show this msg agaon"
when we select the chek box this msg never appeared

I am writing a little VBA application and will sell this to a small company.
However, I want to give them a license to use it only for 3 months.
How can I make sure the application will not work anymore after 3 months?
And how can I program something that will clear the whole VBA ...

I'm back again!
I would be grateful if I could have some help with the following
problem:
I have a spreadsheet that is 306 lines long by 13 coulmns wide. All