LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Userforms, selection based on sheet and password

Hi
I know what I want to do but am not quite sure how to tackle the problem. I
have a workbook with twelve sheets (Jan - Dec) with the departmental expenses
downloaded from our main system. I want to generate a userform that a user
can go into, select the month required and the department that they want the
data for, enter a password that checks the password. If password does not
match department, the data is not shown and the file closes. I have done a
listbox for the worksheet data but am not quite sure how to do the listbox
with password security. Any ideas anyone?
--
Chris
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I unhide/hide a sheet based on pull down selection? Keith Excel Discussion (Misc queries) 1 August 12th 08 04:17 PM
Based on Drop-Down Selection go to that Section on Sheet Golova Excel Discussion (Misc queries) 3 April 17th 07 07:26 PM
Copy Rows to New Sheet based on User Selection in Drop-down List Carlee Excel Programming 0 April 2nd 07 04:46 PM
Moved data to new sheet based on list selection scronk Excel Worksheet Functions 1 October 18th 05 08:08 AM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"