-
Hi there, Firstly apologies if something similar has been answered before, or i've missed something very obvious, i'm by no means a VB expert. Background I have a Worksheet broken down into Sections, at the top of each Section I have a Macro for Users to Show/Hide (the Rows for) that Section...
-
Using Excel 2003, I would like to automate the process of creating a worksheet from a template, got this working, then automate sending this worksheet to a defined distribution list. I tried recording a macro but it stops after the email is called without entering the recipients and then sending the...
-
Does anyone have experience in developing a single file in a team environment? I have been working on this file by myself, but we have finally added one more person. I know you can't share a file that has a VBA project. So how do you go about working on the same file? Thanks
-
I am trying to avoid using sendkeys in one of the application. The code is simple and I am just trying to copy page setup from one worksheet to second using a hack. It selects 2 worksheets and activates the worksheet from which I want to copy the page setup and sends the keys to the page setup dialog...
-
Thanks. Specifically, I mean through the Excel fx feature. When you invoke fx , you get the list of arguments with entry fields, a description of the function, and the opportunity to select help for that function. I haven't found any way to add the description and help.
-
How do you write a help file for an Excel VBA function that is displayed when a user clicks "help on this function"
-
I would like to receive an email notification with a hyperlink to an excel workbook whenever someone completes said workbook (actually a customized template we use for each of our individual projects). After a little digging, one approach seems to be to create a beforeclose event with a customized dialog...
-
I have a question that I am not sure is VBA related…but here it goes. I have one Excel document that has different users enter specific information about a product. The completed document is then emailed and then someone copies the data and pastes into another master Excel document. My questions is:...
-
Hi all, Can anybody tell me how to find out if a cell has a comment attached with it. Using VBA,:- Msgbox activecell.comment.text works ok providing that the cell has a comment. If it hasn't, run-time error 91 is generated. Thanks for any help. John
-
In Excel 2000 when debugging VBA, at a break point I could hover with the cursor over a variable name and a popup box, which Microsoft calls the "Data Tips", would appear showing the current value assigned to the variable. In my current situation using Excel 2003, the data tips do not appear...