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: 2,494
Default userform in a separate workbook?

would putting a userform in a separate workbook cause any issues in this
scenario? the workbook would only contain the form.

there are about 20 identical workbooks, with a sheet for each month. there
is only one workbook open at a time and only the manager enters data into
the workbook.

i was just thinking i could call the form from whatever workbook is open,
enter the data, save the workbook and then load the next workbook.
the form only enters data on the active sheet, so for ease of management,
just wondering if this is a viable solution.
--


Gary



 
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
Range name in separate workbook Arun Excel Discussion (Misc queries) 0 November 30th 06 08:42 PM
Select sheet tabs in workbook & save to separate workbook files stratocaster Excel Worksheet Functions 2 March 1st 06 03:35 PM
workbook sheets into separate files markx Excel Worksheet Functions 1 June 28th 05 04:02 PM
Issuing macro in workbook from separate workbook Nigel Excel Discussion (Misc queries) 1 May 16th 05 05:46 PM
Using the same variable in separate userform modules DarrenW Excel Programming 2 July 11th 03 03:11 AM


All times are GMT +1. The time now is 01:17 PM.

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"