I want to change sheet name as per a particular cell.
Since the sheet name cannot accept special characters such as,
: \ / * [ ] etc., if the user puts name in the cell with any of thes
characters, anywhere in the complete name, say, XYZ*2, error pops u
for debug. I want the user to avoid these characters to be used, b
validating the cell or by VBA code. (not by adding comment to th
cell)
Could someone help me

--
Message posted from http://www.ExcelForum.com