Will a Macro do this? If so, HOW?
I have a tracking spreadsheet going right now. Lots of dates and names.
I would like to set up this sheet so that if I change a status (via dropdown
menu) to complete, it automatically changes all dates to the next calendar
year and clears that 'status'.
Is this possible? Do I need a macro? And how do I set it up? I've never
coded a macro, just recorded them...
...Excel macro or command button to search using a user form
I have a user form which shows info about each student. I want to be able to
enter a student's name in a textbox and have all the fields on the form
populated with the student information.
You need to be a lot more specific on what you are wanting else we have to
make a lot of assumptions.
I would recommend using a combobox instead of a textbox. This way you can
utilize the Change Event and have the students info. automatically filled in
the rest of your userform. I will assume you have a list of students in
Sheet1 in Col. A. Just set the RowSource property of the c...macro query disable download failure
I have a macro which retrieve different queries from the web.
It happens that a resource at that moment isn''t available.
If this happens the querie gives a message which said unable to open
This message i don't want to display (other routines herefor).
I use "Application.DisplayAlerts = False" but this won't help.
Can anybody help me with this problem.
Thank you in advance for any help. I have a worksheet
with the top 9 rows hidden. I can't seem to get them to
I've checked the help file and tried the suggestion there
Edit > Go To > A1 then Format > Row > Unhide but it
doesn't seem to work.
I still can't see those top 9 rows. Any other
suggestions I can try?
Data > Filter
Remove check from AutoFilter
Norman Harker MVP (Excel)
No check by Autofilter, but I tried checking it then
unchecking it just...Saving Input on User Form to Hidden Worksheet
I have a User Form that once it is filled in, it updates several other Work
Books from different Control Buttons.
I need to save the Input on the User Form in one of the Wook Books, so that
if the Work Book is opened again the User Form automatically Fills back in.
Would the Information on the User Form be saved on a hidden Work Sheet in
the Work Book that I want to save it in?
Any Ideas on how to achive this?
You must write code to save and reload informations like this.
Lots of ideas.
Where to save is a question of what's practical. You can write to a sheet in
the ...Disable 'Macro' dialog box...
Thanks Geoff, for the info on how to protect the VBA code.
Have one further question; Now that the workbook and code is protected, I
have sub routines that are run from command buttons. However, it is still
possible to push ALT-F8 to list my routines, then click on a routine, then
Is there a way to disable this option, so that users can not view or run the
list of available routines (I need them to run the routines, only from the
You can do what you want by making each macro a Private macro. This
will preclude that macro from appearing...MACROS SETUP
I would like to set up a macro to do the following:
RUN MACRO = SENDING E-MAIL
Retreive info from several files (specefic worksheet).
Retreive base on number e.g (111-0 or 187-1 etc).Each number has an e-mail
Format to send as e-mail:
1st TEN rows of the worksheet and rows corresponding with the numbers (117-0)
Retreive ONE row above and below numbers
Page break if several numbers has the same e-mail within a file/worksheet
Page break when retreive info from different file
just as a starting point:
Frankf...Excel Sheet does not display properly
I have a basisc Excel chart that included 4 columns and approximately 30
lines, certain columns have different colors...As you can see nothing much...
When I save the document as html, and upload that file to my web server -
people are complaining that they can only see the top portion of the chart -
they keep clicking on the Internet Explorer refesh button and some are able
to view it afterwards, some need to remove their cache - and some don't have
a problem (some times)...We are all using the exact same version of Office,
Does anyone have any suggestions on...Summary sheet including only open projects.
Have a workbook with 2 worksheets. Main worksheet contains all projects,
opened, cancelled and closed. Contains columns A-Q. Column Q is entitled
"Complete". Valid entries in the column appear to be cancelled, yes or
They want the second worksheet to contain only current projects and only
columns A-M. As a project completes they want it to be deleted from the
current projects sheet.
I know there's a way to do this somehow but not very familiar with coding
Two possible ideas:
Record a macro of you clearing sheet 2, and th...Macro to run when opening doc
Is there any way to make a macro run when opening a specific document??
Tks in advance
Yes, you can name the macro 'AutoOpen' or call it from a macro so-named in a normal code module.
Alternatively, you can use a 'Document_Open' macro in the document's 'ThisDocument' module, instead of the 'AutoOpen' macro.
[Microsoft MVP - Word]
"Antonio" <Antonio@discussions.microsoft.com> wrote in message news:965EBAAC-A781-4163-9530-8454EDE1832B@microsoft.com...
> Hi all
&g...Macro Error when moved Xcel Sheets from User's Home Dir to Networ
Xcel spreadsheets Copied from User's Network Home Folder to Another Network
copy \\network\home\userA\*x.s \\network\REPGROUP
Getting "object variable or with block.."
What else I need to copy, when copying from one network location to another.
I reverted back to old way, still same problem
Use FileCopy to copy files.
"Basheer" <Basheer@discussions.microsoft.com> wrote in message
| Xcel spreadsheets Copied from User's Network Home Folder to Another...Print Column Headings on multiple sheets
I have a budget that when printed is one page wide and three tall. How
can I add the column headings to the second and third pages?
click file/page setup and click the sheet tab
click the icon next to rows to repeat at top
select the rows
click the icon again and then ok
"wx4usa" <email@example.com> wrote in message
>I have a budget that when printed is one page wide and three tall. How
> can I add the column headings to the second and third pages?...Macros failing in different language versions of Word
My company wants to standardize on templates across several countries - we
have offices in many countries, but for simplicity I will just talk about UK
and Sweden. My problem is that some features in the English version of Word
do not work in the Swedish version of Word.
For example, StylRef. I use StyleRef in the header margin to refer to
"Heading 1" style. The problem is that it is not called "Heading 1" in the
Swedish version of Word. It is called "Rubrik 1", which translates back to
"Heading 1" of course.
In the UK we use many macro...Time stamp in Excel Sheet
I am looking to entering a value into column A (Data Point), then on column B
(Time Stamp), the time that value A was entered. Then another value will be
entered into A2 and would like the time that Data Point 2 was entered into B2
and so on. I have tried the IF statement =IF(A1,NOW(),"") in B1,B2, B3...
but every time the work sheet reculculates, the Time Stamp column becomes the
same. How can I stop this from happening or am I going about this the wrong
Take a look at http://www.4-consulting.com/News/Ezine_4/Ezine_4_03.htm#t16
"John M" <John M@discussi...Exchanging information from one sheet to another.
I have a spreadsheet with basically inventory on it. I want to make another sheet for a wholesale price list. I want the information from sheet1 to move automatically into sheet2 if a certain cell is empty in sheet1. To be more detailed, I have a list of slabs of granite, if they are not on hold for a customer i want them to be included in the wholesale price list. There is a column for last names of customers who put slabs on hold. If the cell for the customer's name is empty the slab is available to sell. Each slab has it's own row on the spreadsheet. there are about 9 columns for ea...Add the contents of two sheets together
I am looking for a way to add the content of two sheets or even 1 shee
together. I have a large list of part numbers with quantities. Som
of the part numbers are repeated. I would like to add the duplicat
part number quantities together and have just 1 line with the par
number and the total quantity.
Does anyone have any insight?
Message posted from http://www.ExcelForum.com
Sounds like a job for a pivot table. See here for an intro:
"mwiggins367 >" <<firstname.lastname@example.org> wrote...Run Code in General Module Upon Activation of Other Sheets
I have VBA code residing in a general module of a workbook. The outpu
from the code updates several sheets in the workbook. I would like t
automatically Run the code in the general module if any of thes
several sheets are activated (by clicking on the sheet�s tab). How ca
I do this?
Message posted from http://www.ExcelForum.com
You can use the folowwing events in the sheet module(not a normal module)
Right click on a sheet tab and choose view code.
Paste the events in there and press Alt-Q to go back to Excel.
You can copy the code in the event or type the macro name ...Referencing a macro in an Excel formula
Is it possible to reference a macro in an Excel formula. I want to
create a formula that if a condition does not exist in a cell on that
line, then delete the entire line. Is a macro the way to go or is
there some other way?
...How do I copy a graph to new worksheet and get data from new sheet?
When I copy a worksheet with a graph or just copy a graph and paste in
a new worksheet, the source data is still linked to the original
I've tried editing the sorce data to remove the sheet name to try to
make it relative to the current sheet, but that gives me "Error in
Is there a quick way to get the graph to link to the data in the new
worksheet? Even a macro would help, if that's what it takes.
Thanx in advance...
If the chart is embedded in the worksheet, you should be able to copy the
worksheet elsewhere, and the copied chart will point t...Help: Can't display contents of Adobe Acrobat Document in Sheet
Hoping that someone can help with this.
I'm trying to insert an Adobe Acrobat document into an Excel worksheet. I'd
like to see the document contents, not an Icon. According to the Excel help
files, it should be possible to display the file as it shows up in Acrobat
but no matter what I do, I see only an Icon.
I went through the procedure listed in the help files to convert the
document (ensuring that "show as an Icon" is not checked) but nothing makes
any difference! Any idea what I'm doing wrong?
When I try this with other document types (eg AutoCad) everythi...make an excel worksheet (sheet 2) open w/ the cursor located in t.
I have an excel worksheet with three sheets. Sheets 2 and 3 are locked so
that entries can be made in only certain cells. Sheet 3 is linked to sheet 2
so that when an entry is made on sheet 2, the entry appears on sheet 3 in the
I would like sheet 3 to open in the cell the last entry was made (which is
the corresponding cell on sheet 2 because sheet 3 is completly locked except
for the link to sheet 2)
Is there a simple way to perform this task?
...Unhiding All hidden Worksheets with a Macro/VBA Code
Can anyone help me please ?
Whilst working with an Excel Workbook I often hide all unwanted
Worksheets leaving only the ones I need to work on visible.
What I would like to do is have a macro or VBA code to click on a
button to unhide all hidden worksheets rather repeating
Format-Sheet-Unhide to unhide each worksheet.
Any help would be greatly appreciated (Excel version Excel 2000)
44 Married two kids
robertguy's Profile: http://www.excelforum.com/member.php?action=getinf...AutoArchive Properties in Hidden Profile?
A month ago I obtained a new laptop with Win7 and Office/Outlook 2007. My
files, settings, and many things were migrated from my old WinXP with
Office/Outlook 2007 laptop to this one (identical hardware). This migration
caused down-the-wire backups to prompt for a password whenever it wanted to
backup my PST files. The fix for this was to remove the datafiles from
Outlook (Tools --> Options --> Mail Setup --> Data Files) and then re-add
them. It worked, with a downside.
Now, each time AutoArchive runs, it presents me a report with eight entries ...Protect macro
I have a workbook that contains a macro that many people will be
using. can the macro be protected to prevent changes to the macro. I
can protect worksheets but I don't know how to protect a macro.
Open your workbook
Open the VBE
hit ctrl-r to see the project explorer
Select your project in the project explorer window
Tools|VBAProject Properties|Protection Tab
Give it a memorable password (and lock the project from viewing)
But remember, this password, like any password, can be broken by anyone with
enough time or money.
On 07/07/2010 08:57, Paladin046 wrote:
> I have a wo...How do I set a macro to run at specific times?
I have recorded a macro which I want to run automatically every hour. Could
someone tell me how I do this
You can read about the scheduling procedures at Chip Pearson's site:
> I have recorded a macro which I want to run automatically every hour. Could
> someone tell me how I do this