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 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 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 &...

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 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 have a pivotTable that has a pivotfield in Columns "A" and "B". The pivotdata starts in Column "C." Is there a line of code to make vba show the detail (in column C) of a specific pivot item (in either columns A or B)? I am currently using the .Find(...) to find the item (as well as...

Ok, here is the problem. It has been frustrating me for a LONG time (by long time I mean a few hours). I have a macro that hides every rows that ends with a 2 through 0 (e.g. 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, etc) the reason for skipping lines that begin with one...

This seems like a simple question, but does having the screenupdate set to false affect the command ActiveWorkbook or ActiveSheet? To spell it out better if I have screenupdate set to false and have VBA copy a tab to a new workbook will the activeworkbook option work or will VBA still think...

I tried to get an answer to this 6 months ago, but I never got a clear answer (Ref thread707-1562045). I am back with a little more VBA under my belt and I thought ask again. (BTW, thanks to all that tried to help me the first time around) I have got my code to open the website and I get to a...

Is there a way to control where a userform pops up? I have recently been given two monitors at work. My custom form pops up on the other monitor in what I think would be the middle is I had a monitor that large. My problem will be when I remote in the form will not be available on my home...

I have a userform that has three multipage tabs with one listbox per page (also an OK button and a cancel button). I want to let the user click on the one of the multipage tabs and then choose an item from listbox. What actually happens is when I choose the multipage it calls the listbox but...

Hi, first post: I am trying to make an application select multiple parameters from a listbox on a webpage. The HTML for the listbox is as follows: <script> genSelectValueHTML("_P1798642992", 'formWarpRequest', "GL_Period_Name", 'XML', 'prompt', 'listBox', "GL_Period_Name", RANGE_NO_VALUE...