Hi everybody. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
Thanks so much already for all of your help. I have no clue about macros whatsoever but with the help of this forum I was able to mount quite a nice form in excel already. I just have one pickle left to be figured out. Unfortunately I was not able to find a suitable solution for this pickle in google. <o></o>
<o></o>
Here is the case:<o></o>
<o></o>
I have a workbook with 24 worksheets. The first four are forms to be filled out, the following 20 are eAgreements (text) which data from the first 4 worksheets are copied into. Those 20 are not to be edited by users and will be hidden or unhidden according to the information in the 4 forms.<o></o>
In the 3<SUP>rd</SUP> form I have a price table which is to be edited by the user and then copied (by button) into all visible eAgreements as attachment. I have a macro for that. <o></o>
<o></o>
Problem:<o></o>
I need the “price sheet” attachment in each eAgreement to automatically change size with the price table from worksheet 3. I want it to work with buttons that hide/unhide the number of needed lines specified by the user in a cell. <o></o>
So here is what I need:<o></o>
<o></o>
Configure a Button inside "3. PriceSheet" to do the following:<o></o>
1) in "3. PriceSheet": unhide entire rows starting with row 20 and ending with row = [20 + number in cell G19 of "3. PriceSheet"]<o></o>
2) in all worksheets whose names start with "eAgreement" do the following:<o></o>
unhide entire rows starting with row 166 and ending with row=[166 + number in cell G19 of "3. PriceSheet"]<o></o>
<o></o>
Hope someone can help me with this. Thanks so much in advance,
<o></o>
Dominik<o></o>
fficeffice" /><o></o><o
></o>Thanks so much already for all of your help. I have no clue about macros whatsoever but with the help of this forum I was able to mount quite a nice form in excel already. I just have one pickle left to be figured out. Unfortunately I was not able to find a suitable solution for this pickle in google. <o
></o><o
></o>Here is the case:<o
></o><o
></o>I have a workbook with 24 worksheets. The first four are forms to be filled out, the following 20 are eAgreements (text) which data from the first 4 worksheets are copied into. Those 20 are not to be edited by users and will be hidden or unhidden according to the information in the 4 forms.<o
></o>In the 3<SUP>rd</SUP> form I have a price table which is to be edited by the user and then copied (by button) into all visible eAgreements as attachment. I have a macro for that. <o
></o><o
></o>Problem:<o
></o>I need the “price sheet” attachment in each eAgreement to automatically change size with the price table from worksheet 3. I want it to work with buttons that hide/unhide the number of needed lines specified by the user in a cell. <o
></o>So here is what I need:<o
></o><o
></o>Configure a Button inside "3. PriceSheet" to do the following:<o
></o>1) in "3. PriceSheet": unhide entire rows starting with row 20 and ending with row = [20 + number in cell G19 of "3. PriceSheet"]<o
></o>2) in all worksheets whose names start with "eAgreement" do the following:<o
></o>unhide entire rows starting with row 166 and ending with row=[166 + number in cell G19 of "3. PriceSheet"]<o
></o><o
></o>Hope someone can help me with this. Thanks so much in advance,
<o
></o>Dominik<o
></o>
