Search results for query: *

Here is my quandry: We have an Access database that creates forms that is located on a server that anyone can access. The issue we have is that they need to request read-write access to open the file and create a form which then adds the information provided into the form into tables on the...

I have a file that multiple users access at different times of the day. I have a Workbook_Open Event that will password protect the sheets if the work book is opened in read-only access. But what I want to do is if the user clicks the notify button when the alert for somebody being currently...

I had a little snafu that needed to be worked out Application.CommandBars.FindControl(Type:=msoControlButton, ID:=3627).Execute There was a parenthesis missing inbetween the 3627 and the .execute. Still very helpful, thanks combo!

I have code that allows vba to create a module and write code to that module, but the if another user needs to use this macro they have to click "Trust access to VBA project object module" checked. It is a one time thing, but is their away to have the excel options dialog box open so they can...

I was trying to make a calendar. After doing some research I found out that VBA already has the control built in. I almost wanted to kick my self, but then discovered that my employer has that option blocked (not sure why). Skip, I do appreciate the help. Luckily I learned something new.

I found this site that I think will do what I want. Is this what you were talking about? http://www.j-walk.com/ss/excel/tips/tip44.htm

Could you give me a code for an example? I am not sure I am following.

Skip - you work weekends too? :) The buttons' values change depending on which month and year are selected. What I want to have happen is the user click to on a button, that contains a day, the date (in a specific format) is placed in cell... says "A1" for the sake of this discussion. I hope...

How do you notate the files that have been sent on the spreadsheet? Is is a formula in the cell next to the file's name?

I have a form that has multipe command buttons on it. Instead of making 40-50 commandbuttonx_Click subs (the form is a calendar), is there a way to loop through the buttons to see which one was pressed? I recently thought of using togglebuttons, but I am open to suggestions.

Is there a way to store the current Procedure on an OnKey? Example: If you open up workbook "A" this is the code in the ThisWorkbook Object: Private Sub Workbook_Open() With Application .DisplayAlerts = False .OnKey "^{g}", "'" & ThisWorkbook.Name &...

You both rock. Stars for the both of you.

This may be a bizarre question and it may not even have an answer (aside from "NO"). Is there a user form property that will allow the user to scroll/select/edit a spreadsheet while the form is visible? I had in mind something similar to the way that the "Find" form works. Don't ask for the...

I am not sure yet. I have not go to try it (busy with some month end reports for work that I was told took priority). But I am going to try something similar. I will post my code when I get it working to see if it is similar and for you to see if it is another valid way to do it. Thanks again.

So if you want to do that, you need code that 1) defines the criteria, 2) assigns the criteria and 3) remembers the criteria when PIs are added, in order to assign the criteria in the manner you wish." This is exactley what I needed to know. I was thinking that this was an option, but I was...

So you have an array of values that you're comparing the PIs to. Where did THAT come from? Help yourself out, man!!! Do you want to make this a 20 questions deal?" Voight: First, I know I am asking for help, but I am getting a little tired of your sarcasm. We are all professionals here, so...

It isn't difficult, but since the code is working why post it? I really dont see how this is helpful, but here is the code where the items are filtered: For Each pi In pfCPFEC.PivotItems On Error Resume Next varMatch = WorksheetFunction.Match(pi.Name, aryPINames, 0) - 1...

There is no problem with the code. The code is working fine. My problem is with the mechanics of the pivot table. And this is what I am looking to alter with vba code. An Example: Let's say I have in one of my Page Fields Pivot Items "A", "B" and "C." The macro eliminates "C" based on user...

I have a macro that filters certain values from a pivottable, and this works fine, but when I insert new data (with another macro) the pivot table automatically eliminates the new pivot items. What would be the vba code to make the pivottable to accept the new pivot items but still keeping the...

I'm bookmarking this page. Thanks xlbo! This should be the tip of the week.