Recent content by giggs11

Geoff, Funny...I did try that and it didn't work but I tried it again it's ok now. Thanks, Simon

This is my code: I want the user to be able to open up CalNov and CalDec with 1 password. Option Explicit Option Compare Text 'Password to unhide sheets Const pWord = "Calgary" Const pWord1 = "Quebec" Const pWord2 = "Central" Const pWord3 = "Western" Sub HideSheets() 'Set worksheet to...

Ok...it works now but how do I set up 1 password to open up more than 1 worksheet in the same workbook? It works for 1 worksheet.

anotherhiggins: Thanks but how do I set up a password for each worksheet?

Hello: My qestion is how do I send a workbook with 5-7 worksheets in it but set a password for viewing specific workseets(i.e Atlantic workshhet-only user from Atlantic can view this worksheet by entering an assigned password). Is this possible? Thanks!

Thanks. But now how do i show them on the reports? I need one text box showing the Criteria 1(current month) and another showing Criteria 2 (YTD) totals? Also, how would i but in criteria for NOv 1/03 - now? i tried >=11/01/03 and "now".

I was wondering if it was possible to have 2 criteria's when running a query? I want to prompt the user to specify a date range and also have a running total. (i.e Totals for month of Feb and also a running total from Nov - Current date). Is this possible?

Sam, I clicked your site, figure this!!!

VBAjedi, Thanks for your help but the combobox2 still appears but is in a smaller font. I changed the properties to Visible=false. And used the code you wrote. What should I do?

Basically I have a combo box with items: Approved, Declined, Cancelled. What I want to do is prompt the user/ remind the user to select a Decline Reason when Declined is selected from the box. Does anyone know how to do this?

I seem to be having a problem running this Macro. It seems to list all my options in the one cell continously, with no space. I want the user to be forced to choose on option when they space over to the specific cell. Basically it's a tracker with a list of Product Codes. They must chooose...

How do I prompt a user that if C16 has a value($Amount), that C15 must have a code(ProductCode) and vice versa?

Thanks for the suggestion. I changed the setting to AGP and...nothing...screen went blank. So, I reset the CMOS jumpers and tested another video card. VOILA!! it appears the answer is because I have a faulty card..

The "cold video card boot problem" is when the computer consistently does not see the video card when the computer has cooled down, but the computer always sees the video card after the computer has warmed up by waiting five minutes or so and then pressing the reset button.

Hello: Just wondering if anyone knows how to solve a cool boot problem? Is it just a matter of downloading the VGA drivers for my MB? This is what I have: AMD XP 1700 256 MB 40 GB HD Win XP Geforce 440 mx 64MB