event procedure

I am using the bellow event procedure of VBA and i want to restrict certain users from printing this file excluding me. For eg - David, Carly and Rachel are not allowed to print the file but Jim, Antriksh, Grant and Rohit can print the file Private Sub Workbook_BeforePrint(Cancel As Boolean)...

Disclaimer: I have a workbook with protected health information in it (reason why workbook is not attached). Also, I have little experience with workbook and worksheet events. Problem: I have a customer complaining that every time they manipulate a pivottable in the workbook, that the...

I am using Access 2013 and have tried everything to get this to work. I just want a record to be stamped with a modified date after any part of the record is changed. I cannot figure out why this isn't working. I created a new field called Modified On with Date/Time format in table1. I then...

I'm having some trouble coming up with a solution. I have three fields (generally entered in this order); Actual_Hours, Billed_Hours & Billed_Amount. I'm trying to get them working together, to establish a starting point, when Actual_Hours is entered. I was able to auto fill Billed_Hours from...

Hi I am using an event macro that executes when the sheet deactivates. The event procedure sets ranges and resets value in a series of cells. When I copy a range of cells and leave that sheet, the event procedure executes and I lose the ability to paste the range I just copied to another...

Hi I am using the following code to change the data validation source list based on the value in column "B" It was working fine and then stopped. I get the error message at the lines; .Add Type:=xlValidateList, Formula1:="=TempDescriptions" .Add Type:=xlValidateList...

Hi I know this had been asked, I want an event procedure to run only when a specific cell is change, such as "A3". I searched the board and modified some code that I found. I have been using the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range)<?xml:namespace...

Is there a Keyword (such as "Me" or "Parent" etc.) that I could use to Return the Name Property of a Control from within that Control's Event Code. For example: Private Sub cboComboBox1_Change() Dim strControlNameCurrent As String Dim strControlNameOther As String 'With...

Hi everyone, Long time reader, first time poster. App/OS: Excel 2003/Windows XP I am developing a VBA User form which contains three frames. Each frame contains a number of textboxes. Each textbox for date input has a textbox_Enter event which shows a date picker form (using the Calendar...

Ok, I might be making this harder than it seems, but after multiple searches here and elsewhere, I can't seem to find the answer. I have a macro that will add multiple worksheets. When the worksheet is added, is there a way to dynamically create code inside the Worksheet_Activate event...

Following is the code I regularly use when I need Conditional Formatting with more than four conditions. This code works great when you are typing in new data over the old, but I now need to base the formatting on data found in another sheet. For example, in Sheet1 and cell B2 I have a formula...