prevent

Hi, I'm new to VBA and most of what I have learned has been through Google and I have found a lot on this site. I am trying to write a code that will prevent the user from printing the worksheet if two specific cells are blank. I have tried the following codes, none of which have worked. The...

I have a “Schedule Updates” subform to allow users to schedule future changes to a record on a specific date. These future changes populate tbl_ScheduledUpdates Simple Query qry_ScheduledUpdatesBase finds records <=Date() that now need to be changed. Update Query qry_ScheduledUpdates...

Hi, What is wrong with this code?Sub Send_via_email(Cancel As Boolean)'' Send_via_email Macro' Dim blnCancel As Boolean Dim sMail As String Dim rngCell1 As Excel.Range, rngCell2 As Excel.Range sMail = Application.Dialogs(xlDialogSendMail).Show blnCancel = Not...

(Why hasn't Access fixed this? It's been a problem since the beginning of MS Office!!!) I'm tracking calls to customers. So I've got a form including customer info (name, address, etc), and a subform within it for recording call data (date, caller, result code [1-10], notes, etc). The top form...

Excel 2007/Win 7: I need to prohibit users from doing paste operations, i.e. just allow direct data entry via keyboard. I have found code to disable cutcopymode and disable menus and key shortcuts. However, copying text from Word or other application still works and pasting into the formula bar...

I've just upgraded to Excel 2010 from 2003. An internal add-in that is heavily used uses the Application.GetSaveAsFilename method to prompt for file names to be used for an export process (exporting information from the current Excel file into an xml configuration file). In 2003, even if they...

Hi, I see many questions on numbers being formatted to dates, but I have a problem with alpha-numeric items converting to dates. I am importing data from a web page (*.htm,html) for excel 2003. The data I am importing is like JAN14. This changes to 14-Jan (with custom or general format) and if...

Hi Gurus.. I have a textbox where I want user to only type in manually and not copy any text from somewhere and paste it into the textbox. How do I disable the paste option when the cursor is in a textbox. This is what I tried and the reason it failed: Private Sub txtPassword_Enter()...

I want to prevent user from entering certain characters like "+", ",", "&" etc. I could use Data Validating tool or use Private Sub Worksheet_Change. However, validation in both cases is triggered only after user presses enter. I want it to work like KeyPress event for userform controls - user...

Hi, Ive created a Spreadsheet which has name running along B1 to J1 and dates running down A1 to A180 Now i have Name1 is in B1, Name2 is in C1, name3 is in D1, Etc. now for the dates May 1 2009 - may 31 2009 in A1 - A31, then June 1 2009 to june 30 2009 A32 to A61 the problem that i have...