Second Souffle Index du Forum


Problems with hidden rows

 
Poster un nouveau sujet   Répondre au sujet    Second Souffle Index du Forum -> La guilde Second Souffle -> Suggestions
Sujet précédent :: Sujet suivant  
Auteur Message
JoeClark


Hors ligne

Inscrit le: 05 Oct 2017
Messages: 110
Masculin
Point(s): 0
Moyenne de points: 0,00

MessagePosté le: Mar 28 Nov - 08:15 (2017)    Sujet du message: Problems with hidden rows Répondre en citant

Hello. 


Using Excel I created a worksheet that allows other users to enter some data and select data from drop down menus and get a solution. I use worksheet 1 as the user interface and have a bunch of data and formulas on the next worksheet. It works well but I came across two problems and I don't know if they can be fixed. Here they are: 


I have the worksheet protected and only the cells that data entry is needed unlocked. I also have a macro that runs when the workbook is opened. It hides certain rows. The problem is a protected worksheet and macros that hide or unhide rows don't work together. Is there a way past that? I really want to limit the cells that the user has access to but I also need certain rows hidden unless the used decides to unhide them (using another macro tried to a button). 


If the button that I have that hides/unhides certain rows is clicked while the user's cursor is in one of the cells to be hidden then that row is not hidden. The rest are but Excel won't hide that row if it's clicked on. Is there a way to override that? 


I know these are some weird questions but I am trying to lock down this user interface. 




Please help.... 




I didn't find the right solution from the Internet. 
References 
http://www.vbaexpress.com/forum/archive/index.php/t-56604.html 



Animated sales explainer
Revenir en haut
Publicité






MessagePosté le: Mar 28 Nov - 08:15 (2017)    Sujet du message: Publicité

PublicitéSupprimer les publicités ?
Revenir en haut
Montrer les messages depuis:   
Poster un nouveau sujet   Répondre au sujet    Second Souffle Index du Forum -> La guilde Second Souffle -> Suggestions Toutes les heures sont au format GMT + 2 Heures
Page 1 sur 1

 
Sauter vers:  


Portail | Index | Panneau d’administration | creer un forum | Forum gratuit d’entraide | Annuaire des forums gratuits | Signaler une violation | Conditions générales d'utilisation