Im trying the code for the scenario. I got 10 sheets in my workbook. Iwant to create 10 buttons on the fly on the UDF. Each button for eachsheet. The button captions should show the Sheetnames. Now if youclick a button or could also say a sheet, it should pop up anotherinstant form displaying data from that particular sheet. Like if Iclick button1 that displays caption as SheetName1, this shud pop updata for Sheet1 in the workbook.
1) Please don't post the same thing twice with slight variations. (Unlessthe first post has an error, of course, in which case you apologise for thesecond posting).2) "Any suggestions?" About what? If you have a specific question, thenask it.