Replies

I totally agree with the illogical numbering system. The problem now is trying to get them to change their way of thinking (and doing things) which as I’m sure you know, can be even harder.

Thanks for your help though, and a definitive arguement (lol).

Good to Go!

I have attached a sample of what I am trying to do. The page numbering as you can see is a bit odd (not my choice) i.e. T-1, G-1, PP-1 etc. I have been unable to get it to work correctly using chapter numbers.

Thanks,
GoodtoGo

The letter was added manually. I don’t know how to give it a chapter number but could the same thing not by done by using fields? How do I give it a chapter number though?

Thanks!

Yes I am using Adobe Acrobat Professional 7.0 to create the PDF.

Below is part of the print macro that has been used. The only thing that changes is the number in quotes (ie. “1001”). I am not terribly versed in VBA so I hope this can help.

Sub PrintForms()
‘
‘ PrintForms Macro
‘ Macro recorded 11/19/98 by
‘
Sheets(“Pivot Table”).Select
Range(“A5”).Select
ActiveCell.FormulaR1C1 = “1001”
Sheets(“Page 1″).Select
Application.Goto Reference:=”Form”
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Application.Goto Reference:=”Form2″
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Sheets(“Pivot Table”).Select
Range(“A5”).Select
ActiveCell.FormulaR1C1 = “1002”
Sheets(“Page 1″).Select
Application.Goto Reference:=”Form”
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Application.Goto Reference:=”Form2″
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Sheets(“Pivot Table”).Select
Range(“A5”).Select
ActiveCell.FormulaR1C1 = “1003”
Sheets(“Page 1″).Select
Application.Goto Reference:=”Form”
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Application.Goto Reference:=”Form2″
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Sheets(“Pivot Table”).Select
Range(“A5”).Select
ActiveCell.FormulaR1C1 = “1004”
Sheets(“Page 1″).Select
Application.Goto Reference:=”Form”
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Application.Goto Reference:=”Form2″
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Sheets(“Pivot Table”).Select
Range(“A5”).Select
ActiveCell.FormulaR1C1 = “1005”
Sheets(“Page 1″).Select
Application.Goto Reference:=”Form”
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Application.Goto Reference:=”Form2″
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Thanks.

Thanks that works great so far in a quick test! I had tried the other one but was losing the slash for some reason and I’m afraid I don’t know enough about VB to identify where that problem came from. Thanks again!

Thank you all for your help. UnfortunatelyI think it would be quickest just to turn it off though.

I did try that before but had a lot of difficulties with it. Perhaps I’m not as familiar with marking the entries as I could be so I couldn’t get it to work. I know I had a definite problem with making sub entries so gave up. Can my existing hierarchy levels be used without having to go through the entire document and remark everything?

Thanks again.

Thanks, that will certainly be something to bear in mind for next time.

Yes it does do what I want, however when I tried to do the same thing on my actual spreadsheet, no matter how I formatted either coloumn, it still would not work! Finally, I simply retyped the code list with a custom setting and it is now working great.

Thanks for all your help!!!!!!!!

I can’t seem to get them to enter regarless of the cell formatting (number, text, custom etc). I am attaching a sample of the spread sheet and it is column C that I am trying to validate. As you can see, these are codes not numbers but definately, entering as numbers is so much easier.

Thanks

I have just discovered a problem with my cell validation. In the entry cell, if you type a number such as 01 and this number is in the validation list, it still returns an error message of an invalid entry. This happens wheather or not a zero is put in front of the number. I have checked the formatting of the cells to validate and they were both set the same, text, number, general. Entering any other number from 10 onwards is not a problem, why then will it not accept an entry less than 10?

Thanks to all, it does work this way. I believe the problem was the entry field was set as text and it seems to be working now.

Thanks again to all!

If I do it that way, the number cannot be typed into the cell and they would have to choose from the drop down list. Is there not another way?