I have requirement to create calendar from excel data. So i would like to use first tab as calendar with Data, and when user click on particular data wants to open new window to display detail or open new tab with detail.
Not sure is it possible or not , I need to do some similar so we can display data in calendar format and display some detail data in excel.
Thank for your response. I would like to display some data from another sheet in pop window. Can you please provide some example where i can display detail data from another sheet in pop up window.
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
http://www.vbforums.com/showthread.php?t=643002