Programming

VBA Password Recovery
I have a question on an old method on unlocking access to VBA Modules. I am following the process as follows: 1. Create a new simple excel file. 2. In the VBA part, set a simple password (say - 1234). 3. Save the file and exit. 4. Open the file you just created with a hex editor. 5. Copy the line... 20 Jan 2010 07:18

Restricting activation of a form button
I'm using 2 form buttons which runs 2 different subs. The buttons are on the same sheet. I wish to restrict the activation of one of the 2 buttons (assigned to the sub below) to only authorised persons via say, a password prompt? which appears upon clicking the button. Grateful for an example or two of how this... 20 Jan 2010 18:36

RIBBON COLOR
Is there any idea how to change the color of a custom tab different from default theme as in the case of Contextual tabs? Sure would oblige if appropriate XML tags, ideas or address of a source on net is provided. -- Thanx in advance, Best Regards, Faraz ... 20 Jan 2010 05:07

prompt password for a worksheet
how can i prompt a user to enter a password when he tries to unhide a hidden sheet . the workbook has to be password protected i.e when i open a workbook all the hidden sheets have to be password protected . ... 20 Jan 2010 14:04

copying cell comment from one sheet to another
I need to copy a cell value and a comment if it exists from one sheet to another sheet in the same workbook. I tried the following code but it fails on the if statement with the error message: Object variable or With block variable not set The code works fine if the source cell has a comment and only fails whe... 20 Jan 2010 01:52

Strip file extension from fiel name with multiple periods. "file.9
Try using INSTRREV , it gets the first "." from the end. -- HTH, Barb Reinhardt "Fan924" wrote: I am using this to strip the file extension off of a file name Range("G6").Value = Left(ActiveWorkbook.Name, InStr (ActiveWorkbook.Name, ".") - 1) It messes up with multiple "." How do I str... 19 Jan 2010 20:21

Routine does not run when workbook is opened
I have a routine in workbook1 that opens and updates a number of other workbooks when workbook1 is opened. Everything was fine until I got a new computer (both PCs are running XP SP3 and Excel 2003). Now workbook1 will not open or run when I try to open it from windows explorer or from scheduled tasks. The o... 20 Jan 2010 11:48

koşullu biçimlendirme
Microsoft Office Excell programını kullanaranak, "Koşullu Biçimlendirme" komutunu kullanarak hücreleri nasıl renklendirebilirim? ... 19 Jan 2010 14:41

Where do I paste in the following Access SQL code into my routine?
Access code: SELECT AXA_BILLING1.[Profile Name], Sum(AXA_BILLING1.[Parts In]) AS [SumOfParts In], Sum(AXA_BILLING1.[Parts Out]) AS [SumOfParts Out] FROM AXA_BILLING1 GROUP BY AXA_BILLING1.[Profile Name]; VBA code: Dim conDB As ADODB.Connection Dim recDB As ADODB.Recordset Dim i As Integer Sheets(... 19 Jan 2010 11:17

MsgBox when the cell is empty
Hi, I want a msgBox when a cell i empty, I can´t get the cod to work, do anyone know how to do this? My code are Dim Period As Date Period = ActiveSheet.Range("b3") If Period="" Then MsgBox "Du har glömt att välja sorteringsperiod", vbCritical Exit Sub -- Best regards Mia ... 19 Jan 2010 09:03