I am using the code below to open multiple workbooks in their own instance of Excel.
On my system, as well as most of the ones I've tested it on, enabling macros in the "parent" workbook, i.e. the one that contains the code, leaves them automatically enabled in the new session of Excel, as though the settings are carried over.
However, recently I've found a few systems where this is not the case. Enabling macros in the parent workbook opens the others, and then I have to enable macros again in each of the new sessions. Is there a way to fix this? All of the systems mentioned above have macro settings set to "disable with notification" and this cannot be changed.
I have an Excel 2003 program that contains macros. One of the macros hides certain command bars and disables the worksheet menu bar. On close the opposite is true. The problem is, if a user uses the disable macros when opening then the worksheet menu bar and other command bars are still available. I would like to hide all of the data sheets and display another sheet that would normally be hidden displaying a message that the macros have to be enabled for the program to work correctly if disable macros is chosen. When the enable macros are used I would like the Error page to be hidden.
I recently reformatted my hard drive. When I re-installed Office 2007, I was unable to run a Workbook that has a Macro in it. First, I went to Add-ins and added the Solveradd-in. When I opened the workbook, I enabled Macros. However, all I get is a maessage saying that the MVB did not compile. I know there are some things you have to do to solve this, but I cannot remember the procedure I went thru 2 years ago to get this to work. Does anyone know what steps I must take?
I have a workbook with that contains macros on a worksheet. When I open the worksheet, I sometimes forget to enable the macros.
Questions
1.Sometimes I get the message about macros being in the file that I'm opening and sometimes I don't - I don't understand why it doesn't pop up all the time and be consistent.
2. If I don't get the pop up screen or if I do but forget to enable the macros, I get reminded when I try to run a macro. For example, I have a check box and try to check it but I get the message that the macro has to be enabled. So I enable it, but the macro doesn't run. I have to uncheck and then recheck the box to get it to run.
i am trying to work out why i always have to enable macro's when i open some of my files that i have macros in, as i save them as enable macro file. I run excel 2007 as there are files i want to open without clicking on the enable button.
if you open a workbook & choose not to enable macros, is there any way to later change your mind & set macros to enabled without having to close & reopen the workbook?
Is it essential to enable macros in whatever the pc i use, if i am interested in using a form which i created in a different pc with macros. is there a way to avoid this. because each and every time i dont want to change the settings in excel in other pc. the form which i create will be filled by my colleagues and they have to send it back to me.
I'd like to use VBA to open 3 workbooks in their own session/instance/etc of Excel 2007. Ideally, there will be one main workbook, that upon opening will subsequently open the other 3 workbooks.
Also, when I open that first main workbook, I will obviously have to enable macros to get any code to run. Is there a way to carry this enabling of macros over to the other sessions to avoid having to enable macros in all 3 other workbooks? (Changing my security settings isn't an option)
How to close this connection?. If I send alt F4 using sendkeys method, it is going to the computer to which vncviewer is connected, not to the computer running vncviewer?
If you take a look at the spreadsheet you'll see that there are 11 sessions. I'd like to figure out a way by looking at the attendance log to get the percentage/number of people from a certain unit that attended each session. The Y's means that they were present and the N's means that they weren't.
I tried = countif( range,"12WT") which I guess is wrong because it only counts the number of times the word 12WT appears. It doesn't count the number of time a person from 12WT attended the session which is what I'm looking for. How do I go about getting the percentage of people that attended from each unit?
For all the units that didn't attend, is there a formula that would list the units that didn't attend according to the session number? For instance for session one, someone for EC, 9WT, didn't attend. Is there a way that the end result for the formula could be: EC,9WT. Or, does the result for every formula always have to be numeric?
I need to be able to have a time counter on my excel sheet that whenever I open my sheet, it automatically starts counting the number of seconds, minutes and hours spent. I also need my sheet to be able to satrt from where it stopped and also have a reset function built in.
This is the code I use to start a bash session and run a .sh:
[Code]....
It works well but it is a long-running program and I would like to close down Excel, or run different sessions of Excel, while it is running. Right now, if I close Excel while the bash is running, the external script stops.
Is there a modification to this command line that would safely sever the link between Excel and the bash session?
I am trying to create a 'simple' spreadsheet which will allow me to check how many children are going to be attending my nursery and split them into the different age bands.The columns I am using at the moment are
Name D.o.B Start date Mon AM Mon PM Tues AM Tues PM
I need to be able to split this data into three age groups: Babies (under 2 years), Tweenies (2-3 years) and Pre-school (3+).I would also like the formula to take account of the start date so to remove children from the list who will not have started by this data.
The idea is that I can use this as a quick look to see if I can accept another child / give me an idea of staffing needs. I know there is software out there that can do all this and more, and used to use them on previous nurseries, however this is a new start nursery which does not have the cash to pay for the software at the moment so I am looking to save myself a few hours of checking it all myself until the nursery is up and running and can afford the software which we would hopefully buy in year 2.
I ran a Home Service Massage, with ten massagers and it's continually growing. I know I'm supposed to use a database for this, but I'm not very good in creating one. I am however confident in using MS Excel, so in a much as possible, I only want to use MS Excel, and strictly use formulas (if I can get away with it).
Anyway, I keep customer records in one tab, and all their personal info is listed there. There are two types of columns, which I'd like to call 'static' and 'automatic'.
Static columns includes Unique ID (number), Name, Address, Phone Number, etc.
Automatic columns, by the term I used, is filled automatically. This includes the total number of hours they have availed the massage from us, the names of massagers who serviced them, --- and my biggest issue --- the date of last massage. I can manually input this, but I normally forget, so I want this filled automatically.
Aside from customer tab, I have one tab for each massager. First column is the date, then 48 columns for time. Starting from 8AM, 830AM, 9AM... 730AM. Hence I have 48 of them. Each column is equals to 30mins of massage availed. I copy and paste the Unique ID from customer tab.
so A2:A32 are dates, and B2:BC50 is where I copy paste the unique ID. B1:BC1 are time labes.
Is it possible for me, just by using formulas, to populate the 'last massage date' column?
I have a worksheet that I protect from cell deletions by disabling the command function for 'delete' using the following CommandBars.FindControl(ID:=292).Enabled = False
I execute this code in two subs:
Private Sub Worksheet_Change(ByVal Target As Range) CommandBars.FindControl(ID:=292).Enabled = False
... and ...
Private Sub Worksheet_SelectionChange(ByVal Target As Range) CommandBars.FindControl(ID:=292).Enabled = False
... all fine and good, works great only problem is...
once disabled this function is NOT re-enabled when I leave the workbook.
When the sheet deactivates I run this: ______________________________________________________________ Private Sub Worksheet_Deactivate() CommandBars.FindControl(ID:=292).Enabled = True End Sub ____________________________________________________
that works fine while I am changing worksheets within the workbook.
But it doesn't do for this function to remain disabled even after I close the workbook and then it's disabled in all the other workbooks.
What I need is to have the code re-enable this function when the workbook closes or when I activate a different workbook so that the function is only disabled within the specific worksheet of the specific workbook and it remains enabled everywhere else ESPECIALLY after I close that sheet and workbook where I have it disabled!
I tried this:
______________________________________________________________ Private Sub Workbook_Deactivate() CommandBars.FindControl(ID:=292).Enabled = True End Sub ____________________________________________________
I have a userform with, amongst other controls, a ListBox1 and a CommandButton1.
I have set the CommandButton1 to enabled = False in the properties and need it to be enabled when at least 1 item in the ListBox is selected (the ListBox is multiselect).
I have the following code, but it is not working.
Private Sub ListBox1_Click() CommandButton1.Enabled = True End Sub
Both controls are in the same userform and the names correct.
I have a shared workbook with four buttons executing different macros. Problem is that some of the users should only be able to use two of the buttons. To avoid that they accidently press the "restricted buttons" i would like a password (or keyboard shortcut) to enable these.
Hi, The purpose of this macro was to control the time this excel file was open because many users modify it. I decided to create a splash screen (userform) to display a message to the user saying "your session time of 15min is up"
The problem is, the first time I open the file everything works fine. But after I close it (just the workbook not excel), It opens itself for some reason and gives me a debug error message. Perhaps the timer is never stopped?
I call "StartTimer10min" on workbook open and "StopTimer" before workbook close.
I have some command buttons on a worksheet that I would like to disable, preferably make not visible, until a specific person logs in. I already have code to display worksheets, or hide them, depending on who is logged in. I would like to just add this code to the end of the login procedure, to make these buttons only visible when that person is logged in.
Here i am attaching the excel sheet where macro is enabled. I have added macros in last spread sheet (Consolidated) everything is working fine. Whats messing is i have copied a macro for the entire workbook, which will disable Copy/Pase/Cut option to all engineers. But problem is its disabled for me as well, every time i have to delete the code for copy/cut options. I just want cut/copy option in the last worksheet (Consolidated) where i can get all the result with out touching the rest of the sheets.
I have a sheet with around 3,000 rows of data. I need to be able to enable/disable different comibinations of three checkboxes based on the value of a cell in column D as follows:
If Band says £0k - £75k then all three check boxes should be disabled If Band says £75k - £250k then the Step 1 check box should be enabled but the Step 2 and Step 3 check boxes should be disabled If Band says £250k - £500k then the Step 1 and Step 2 check boxes should be enabled and the Step 3 check box should be disabled If Band says £500k plus then all three check boxes should be enabled
When a checkbox is disabled I'd like it to appear visible but greyed out so it is obvious the option is not available, maybe via conditional formatting. I don't know if this can be achieved within any code rather than having to manually add conditional formatting afterwards?
I've attached a sample to demonstrate. Is this possible to achieve? I'm open to alternative approaches as well if this makes things easier to do. The mere idea of adding 9,000 plus check boxes if already scary!
A coworker just ran something by me that i'm quite frankly baffled by. After running a macro, the undo function becomes disabled up to the point of when the macro was ran. I've done a quick search through the forums and can't seem to find this question so i thought i'd ask.
Is there an option to toggle somewhere or 3rd party addon that keeps Undo enabled after running a macro? On a similar topic for my own curiosity, what's the reason that it disables?
I have always saved each macro on a single workbook, saved the workbook using the macro name, so I can go use that spreadsheet for a specific issue. Now, however, my job role is changing to where I have to do a lot of things like get a file from Bob . . . slice and dice and then forward it on to Carol, etc. Then I have to save spreadsheet A to this directory, spreadsheet B to that directory . . . .
I am sure there is, I just can't get my head around it to have one spreadsheet that has ALL my macros that would be available to me on other spreadsheets? I tried using "show macros in all open workbooks"
I currently have a 70 page spreadsheet with similar data that needs representing in pie chart format. All the column headers are the same and I only need 2 columns (A and T).
There are however different numbers of rows. Is it possible to write a macro to detect the number of rows before it draws the relevant pie chart (I've managed the pie chart bit!!)
See attached example, same concept but cant post real data.
I have a userform that has the same type information on 3 different entities (name, address, phone, etc). The same research is required on each one i.e. you need to look up the zip code for each). Therefore I have a bank of buttons on each page of the multipage form. Each button does the same thing depending on which page you are on. The following is my code to copy some information and open another application depending on which page you are on and which type entity.
My question is how can I combine these into one so my module is not 3' long.
